| How to apply CROSS JOIN for combinations? |
|
The following
T-SQL database script in SSMS 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
|
 |
| The World Leader
in SQL Server 2008 Training |
| Order SQL 2008 GRAND SLAM Today! |
| The Future is just a CLICK away! Your Future! |
| SQLUSA.com
Home Page |
Copyright 2005-2010, SMI Corp. All Rights Reserved.
SQL Server 2008 is a program product of Microsoft Corporation. SQL Server 2005 is a program product of Microsoft Corporation. SQL Server 2000 is a program product of Microsoft Corporation. |
|