Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Ms Sql Server 2000 Identity Columns Gaps
With regards to Identity columns in ms sql server 2000, what is the best way to manage the gaps after rows have been deleted? I read somewhere about using : DBCC CHECKIDENT (TableName, RESEED,1) DBCC CHECKIDENT (TableName, RESEED) But i think it only works if the rows are removed from the... -
-
SQL query help
My apologies. I forgot to mention I am using MS Sql server 2000. SQL SERVER:- select top 3 * from a1 where ss <= '11.08.2002' This almost works but it returns the first 3 rows in my table instead of the 3 preceding 11.08.2002 ... is there a corresponding BOTTOM function??? i couldn't find... -
SQL query help
Thanks for help. But that doesn't seem to do exactly what I wanted. It works in the case of the example because the first 3 rows are the correct ones, however when there are more rows preceding them the wrong ones would be returned table a1 ss 20.08.2002 10:23:34 18.08.2002 10:23:34... -
SQL query help
Hi, I am having problems making a query that will return the rows for a specified date AND the preceding N number of days (not necessarily just date - N days). I.e. table date column consists of: Date Column ... Aug 5,2002 Aug 7,2002 Aug 8,2002 Aug 10,2002 Aug 12,2002 ... If i want to...
