Using GO Repeat To Fill Tally Table

-- tally table used for parsing smallish columns dbo.TinyTally(N tinyint IDENTITY PRIMARY KEY);
SET IDENTITY_INSERT dbo.TinyTally ON;
GO
-- Prime the table first
INSERT dbo.TinyTally(N) VALUES(IDENT_CURRENT('dbo.TinyTally'));
GO
INSERT dbo.TinyTally(N) VALUES(IDENT_CURRENT('dbo.TinyTally')+1);
GO 254 -- Really cool tidbit I picked up from SQL Saturday #40 (will now repeat batch 254 times!)
SET IDENTITY_INSERT dbo.TinyTally OFF;
GO
SELECT * FROM dbo.TinyTally;
GO