CREATE TABLE dbo.Options ( OptionValue varchar(2)) INSERT INTO dbo.Options VALUES ('A1'), ('B2'), ('C3'), ('D4'), ('E5') SELECT a.OptionValue, b.OptionValue FROM Options A CROSS JOIN Options B where A.OptionValue < B.OptionValue order by a.OptionValue