Listing 1: Creating and Populating T1 SET NOCOUNT ON; USE tempdb; GO IF OBJECT_ID('dbo.T1') IS NOT NULL DROP TABLE dbo.T1; GO CREATE TABLE dbo.T1 ( id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY DEFAULT(NEWSEQUENTIALID()), dt DATETIME NOT NULL DEFAULT(GETDATE()), val INT NOT NULL ); INSERT INTO dbo.T1(val) VALUES(10); WAITFOR DELAY '00:00:10'; INSERT INTO dbo.T1(val) VALUES(30); WAITFOR DELAY '00:00:10'; INSERT INTO dbo.T1(val) VALUES(20); WAITFOR DELAY '00:00:10'; INSERT INTO dbo.T1(val) VALUES(50); WAITFOR DELAY '00:00:10'; INSERT INTO dbo.T1(val) VALUES(50); WAITFOR DELAY '00:00:10'; INSERT INTO dbo.T1(val) VALUES(20);