Dynamic tally:
;WITHNumbers (N) AS
(
SELECTTOP (25000)
ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
FROMmaster.sys.columns
CROSS
JOINmaster.sys.columns C2
)
SELECT'A' + RIGHT((10000000000 + N), 9)
FROMNumbers;
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi