CREATE TABLE foo (fooID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, data1 TIMESTAMP, data2 INT, data3 CHAR(250))
GO
INSERT INTO foo(data2, data3)
SELECT CHECKSUM(name), name
FROM syscolumns
UNION ALL
SELECT CHECKSUM(name+'foo'), name+'foo'
FROM syscolumns

SET IMPLICIT_TRANSACTIONS OFF
SET LOCK_TIMEOUT 5
GO
DECLARE @maxID BIGINT, @minID BIGINT
SELECT @maxID = MAX(id), @minID = MIN(ID) FROM sysobjects

INSERT INTO foo (data2, data3)
SELECT TOP(1) CHECKSUM(id), name
FROM sysobjects WHERE id >= (RAND()*(@maxID-@minID))+@minID
GO 20000

DECLARE @sid AS INT;

WITH CTE AS
(
	SELECT ROW_NUMBER() OVER (ORDER BY name) AS row,
					name
	FROM sys.columns
)
INSERT INTO foo (data2, data3)
SELECT row, 'foo123'+name
FROM cte
ORDER BY row DESC
OPTION(MAXDOP 1)

SELECT @sid = SCOPE_IDENTITY()

SELECT fooid, fooid + data2 - @sid, data2
FROM foo
WHERE data3 LIKE 'foo123%'
	AND fooid + data2 - @sid <> 1