How to create a pivot query in sql server without aggregate function

by 
SELECT *
FROM
(
SELECT [Period], [Account], [Value]
FROM TableName
) AS source
PIVOT
(
    MAX([Value])
    FOR [Period] IN ([2000], [2001], [2002])
) as pvt

Another way,

SELECT ACCOUNT,
      MAX(CASE WHEN Period = '2000' THEN Value ELSE NULL END) [2000],
      MAX(CASE WHEN Period = '2001' THEN Value ELSE NULL END) [2001],
      MAX(CASE WHEN Period = '2002' THEN Value ELSE NULL END) [2002]
FROM tableName
GROUP BY Account

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. SQL where clause odd behavior [closed]
  3. How do I obtain a Query Execution Plan in SQL Server?
  4. How do I escape a single quote in SQL Server?
  5. Simple way to transpose columns and rows in SQL?
  6. Only inserting a row if it’s not already there
  7. Unpivot with column name
  8. Selecting data from two different servers in SQL Server
  9. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  10. SQL JOIN vs IN performance?
  11. Most efficient way in SQL Server to get date from date+time?
  12. Convert varchar into datetime in SQL Server
  13. TSQL Pivot without aggregate function
  14. How to generate a range of dates in SQL Server
  15. SQL RANK() versus ROW_NUMBER()
  16. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  17. How do I delete from multiple tables using INNER JOIN in SQL server
  18. Check if a row exists, otherwise insert
  19. SQL : BETWEEN vs =
  20. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  21. How do I perform a GROUP BY on an aliased column in SQL Server?
  22. How do I make a composite key with SQL Server Management Studio?
  23. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  24. TransactSQL to run another TransactSQL script
  25. Getting Dates between a range of dates
  26. How do you copy a record in a SQL table but swap out the unique id of the new row?
  27. SQL – Call Stored Procedure for each record
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment