Pivot using SQL Server 2000

by

I realize this is two years old, but it bugs me that the accepted answer calls for using dynamic SQL and the most upvoted answer won’t work:

Select P.ProductId, P.Name
    , Min( Case When PM.MetaKey = 'A' Then PM.MetaValue End ) As A
    , Min( Case When PM.MetaKey = 'B' Then PM.MetaValue End ) As B
    , Min( Case When PM.MetaKey = 'C' Then PM.MetaValue End ) As C
From Products As P
        Join ProductMeta As PM
            On PM.ProductId = P.ProductId
Group By P.ProductId, P.Name

You must use a Group By or you will get a staggered result. If you are using a Group By, you must wrap each column that is not in the Group By clause in an aggregate function (or a subquery).

More Related Contents:

  1. How to Join to first row
  2. Find last sunday
  3. Is it possible to write single query on two table which are not connected to each other?
  4. How to create a specific SQL Server stored procedure? [closed]
  5. SQL Server dynamic PIVOT query?
  6. SQL Server – Best way to get identity of inserted row?
  7. Should I use != or for not equal in T-SQL?
  8. How to update two tables in one statement in SQL Server 2005?
  9. SQL Server Process Queue Race Condition
  10. How should I pass a table name into a stored proc?
  11. Is the NOLOCK (Sql Server hint) bad practice?
  12. Creating an index on a table variable
  13. SQL – Subtracting a depleting value from rows
  14. OR is not supported with CASE Statement in SQL Server
  15. How to set variable from a SQL query?
  16. How to drop SQL default constraint without knowing its name?
  17. Equivalent of Oracle’s RowID in SQL Server
  18. Dynamic update statement with variable column names
  19. How to select only the first rows for each unique value of a column?
  20. SQL Server (TSQL) – Is it possible to EXEC statements in parallel?
  21. SQL “between” not inclusive
  22. Unordered results in SQL
  23. Using PIVOT in SQL Server 2008
  24. SQL Server replace, remove all after certain character
  25. How to find column names for all tables in all databases in SQL Server
  26. Inserting rows into a table with one IDENTITY column only [duplicate]
  27. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  28. How do I compare 2 rows from the same table (SQL Server)?
  29. COALESCE Function in TSQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment