-- what about IDENTITY??

SET NOCOUNT ON

-- Just a simple test table

IF (OBJECT_ID('tempdb..#my_tab') IS NOT NULL)

DROP TABLE #my_tab

CREATE TABLE #my_tab (id INT NOT NULL IDENTITY(1000,1), any_date DATETIME)

-- Create 100000 test values

PRINT 'Test data'

PRINT '-> Creating'

DECLARE @i INT

SET @i = 0

WHILE (@i < 100000)

BEGIN

INSERT INTO #my_tab (any_date) VALUES (DATEADD(MINUTE, @i * -1, GETDATE()))

SET @i = @i + 1

END

PRINT '<- done'