The following T-SQL database script in Query Editor demonstrates the use of the CROSS JOIN to generate a combination of alphanumeric characters. The new SQL Server 2008 INSERT...VALUES... syntax used to populate the AlphaNumeric table.

USE TempDB

GO

-- DROP TABLE AlphaNumeric

CREATE TABLE AlphaNumeric (Letter char(1))

GO

INSERT AlphaNumeric

VALUES

('1'),

('2'),

('3'),

('4'),

('5'),

('6'),

('7'),

('8'),

('9'),

('0'),

('q'),

('w'),

('e'),

('r'),

('t'),

('y'),

('u'),

('i'),

('o'),

('p'),

('a'),

('s'),

('d'),

('f'),

('g'),

('h'),

('j'),

('k'),

('l'),

('z'),

('x'),

('c'),

('v'),

('b'),

('n'),

('m')

GO

SELECT LetterCombo = a1.Letter+a2.Letter

FROM AlphaNumeric a1

CROSS JOIN AlphaNumeric a2

ORDER BY LetterCombo

GO