D.rn

, ASCII_ORD.ord_value

, ASCII_ORD.replicate_count

-- CHAR converts a number to a character

, CHAR(ASCII_ORD.ord_value) AS ord_value_as_character

-- REPLICATE repeats a string N times

, REPLICATE(CHAR(ASCII_ORD.ord_value), ASCII_ORD.replicate_count) AS RepeatedCharacter

-- CONCAT is a null and type approach for string building (requires 2012+)

, CONCAT(CHAR(ASCII_ORD.ord_value), ASCII_ORD.replicate_count) AS ConcatenatedCharacter

(

-- Generate 0 to N-1 rows

SELECT TOP (300)

ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) -1

FROM

sys.all_columns AS AC

)D(rn)

CROSS APPLY

(

-- There are 26 characters in the English language

-- 65 is the ASCII ordinal position of a capital A

SELECT

D.rn % 26 + 65

, D.rn / 26 + 1

) ASCII_ORD(ord_value, replicate_count)

ORDER BY

D.rn

OFFSET 20 ROWS

FETCH NEXT 30 ROWS ONLY

;