| How to apply CROSS JOIN for combinations? |
|
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
|
 |
| SQLUSA - The Best SQL Server
2008 Training in the World |
|