Viewing 3 posts - 1 through 3 (of 3 total)
Another way to do it is by using the Tally table. Check out Jeff Moden's article http://qa.sqlservercentral.com/articles/T-SQL/62867/.
Here's some example code (how i use it on our systems):
SET ANSI_NULLS ON
GO
SET...
February 25, 2011 at 1:09 am
#1291392
Thank you for the reply Hugo, that article was indeed the source of the quote.
April 20, 2010 at 1:44 am
#1154363
Although I knew of the possibility to reseed and explicitly adding identity values to a table, I never considered the fact that it made it possible to add non-unique values...
April 20, 2010 at 1:02 am
#1154349