How to simulate UNPIVOT in Access?

by

This query …

SELECT ID, A, B, C, [Key 1] AS key_field
FROM tblUnpivotSource
UNION ALL
SELECT ID, A, B, C, [Key 2] AS key_field
FROM tblUnpivotSource
UNION ALL
SELECT ID, A, B, C, [Key 3] AS key_field
FROM tblUnpivotSource;

… returns this recordset (using your sample table values as tblUnpivotSource) …

ID A B C key_field
-- - - - ---------
 1 x y z         3
 2 x y z        57
 1 x y z       199
 2 x y z       234
 1 x y z       452
 2 x y z       452

More Related Contents:

  1. SQL Server : Columns to Rows
  2. Unpivot with column name
  3. SQL transpose full table
  4. Top n records per group sql in access
  5. Achieving ROW_NUMBER / PARTITION BY in MS Access
  6. Editing Record issues in Access / SQL (Write Conflict)
  7. How do I create a table alias in MySQL
  8. CONCAT equivalent in MS Access
  9. SQL Unpivot multiple columns Data
  10. Is it possible to write single query on two table which are not connected to each other?
  11. select yesterday date in where condition
  12. Import CSV file into SQL Server
  13. Are there any disadvantages to always using nvarchar(MAX)?
  14. Creating an index on a table variable
  15. Is there a LastIndexOf in SQL Server?
  16. Table-less UNION query in MS Access (Jet/ACE)
  17. What is best tool to compare two SQL Server databases (schema and data)? [duplicate]
  18. What is the difference between using a cross join and putting a comma between the two tables?
  19. How do I calculate a running total in SQL without using a cursor?
  20. Concat field value to string in SQL Server
  21. SQL “between” not inclusive
  22. Benefits Of Using SQL Ordinal Position Notation?
  23. SQL Server replace, remove all after certain character
  24. Does UNION ALL guarantee the order of the result set [duplicate]
  25. Inserting rows into a table with one IDENTITY column only [duplicate]
  26. How to find sum of multiple columns in a table in SQL Server 2005?
  27. How to retrieve field names from temporary table (SQL Server 2008)
  28. When using GETDATE() in many places, is it better to use a variable?
  29. SQL SERVER DATETIME FORMAT
  30. Insert all values of a table into another table in SQL

Leave a Comment