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