CREATE TABLE #Temp ( ) DECLARE @position INT SET @position = -1 WHILE(@position < 1) BEGIN INSERT INTO #Temp () SELECT * FROM mytable SET @position = @position + 1 END SELECT * FROM #Temp