Return all possible combinations of values on columns in SQL

by

Assuming at least SQL 2005 for the CTE:

;with cteAllColumns as (
    select col1 as col
        from YourTable
    union
    select col2 as col
        from YourTable
)
select c1.col, c2.col 
    from cteAllColumns c1 
        cross join cteAllColumns c2 
    where c1.col < c2.col
    order by c1.col, c2.col

More Related Contents:

  1. T-SQL SEQUENCE runs out, no cycle, what happens?
  2. LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
  3. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  4. Find a value anywhere in a database
  5. Function to Calculate Median in SQL Server
  6. How to check if a column exists in a SQL Server table
  7. Sql Server string to date conversion
  8. Get first day of week in SQL Server
  9. Select columns from result set of stored procedure
  10. Pass Dictionary to Stored Procedure T-SQL
  11. Get dates from a week number in T-SQL
  12. SQL Server: How to select all days in a date range even if no data exists for some days
  13. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  14. Date conversion and culture: Difference between DATE and DATETIME
  15. TSQL: How to convert local time to UTC? (SQL Server 2008)
  16. How to check if a database exists in SQL Server?
  17. How to remove accents and all chars a..z in sql-server?
  18. tsql returning a table from a function or store procedure
  19. How can I do something like: USE @databaseName
  20. How can I determine in SQL Server if a dateTime range overlaps another
  21. How do you change the datatype of a column in SQL Server?
  22. SQL Server Query – groupwise multiplication
  23. Getting week number off a date in MS SQL Server 2005?
  24. How to reuse calculated columns avoiding duplicating the sql statement
  25. How do I move a table into a schema in T-SQL
  26. How to use RANK() in SQL Server
  27. How can I insert binary file data into a binary SQL field using a simple insert statement?
  28. How to wait for 2 seconds?
  29. What is the meaning of “#” in front of a table name in TSQL?
  30. T-SQL for finding Redundant Indexes

Leave a Comment