Listing 5: Creating and Populating T2

IF OBJECT_ID('dbo.T2') IS NOT NULL
  DROP TABLE dbo.T2;
GO
CREATE TABLE dbo.T2
(
  id  BINARY(16) NOT NULL PRIMARY KEY,
  dt  DATETIME   NOT NULL DEFAULT(GETDATE()),
  val INT        NOT NULL
);
GO

DECLARE @my_new_bin_seqid AS BINARY(16);
EXEC dbo.usp_get_new_seqid @new_bin_seqid = @my_new_bin_seqid OUTPUT;
INSERT INTO dbo.T2(id, val) VALUES(@my_new_bin_seqid, 10);

EXEC dbo.usp_get_new_seqid @new_bin_seqid = @my_new_bin_seqid OUTPUT;
INSERT INTO dbo.T2(id, val) VALUES(@my_new_bin_seqid, 30);

EXEC dbo.usp_get_new_seqid @new_bin_seqid = @my_new_bin_seqid OUTPUT;
INSERT INTO dbo.T2(id, val) VALUES(@my_new_bin_seqid, 20);

EXEC dbo.usp_get_new_seqid @new_bin_seqid = @my_new_bin_seqid OUTPUT;
INSERT INTO dbo.T2(id, val) VALUES(@my_new_bin_seqid, 50);

EXEC dbo.usp_get_new_seqid @new_bin_seqid = @my_new_bin_seqid OUTPUT;
INSERT INTO dbo.T2(id, val) VALUES(@my_new_bin_seqid, 50);

EXEC dbo.usp_get_new_seqid @new_bin_seqid = @my_new_bin_seqid OUTPUT;
INSERT INTO dbo.T2(id, val) VALUES(@my_new_bin_seqid, 20);