TSQL Pivot without aggregate function

by

yes, but why !!??

   Select CustomerID,
     Min(Case DBColumnName When 'FirstName' Then Data End) FirstName,
     Min(Case DBColumnName When 'MiddleName' Then Data End) MiddleName,
     Min(Case DBColumnName When 'LastName' Then Data End) LastName,
     Min(Case DBColumnName When 'Date' Then Data End) Date
   From table
   Group By CustomerId

More Related Contents:

  1. SQL Server dynamic PIVOT query?
  2. Simple way to transpose columns and rows in SQL?
  3. T-SQL dynamic pivot
  4. Dynamically create columns sql
  5. TSQL PIVOT MULTIPLE COLUMNS
  6. Dynamic Pivot Columns in SQL Server
  7. Pivot data in T-SQL
  8. Using PIVOT in SQL Server 2008
  9. Convert text to system date format [duplicate]
  10. How to get a particular preceding value of a column in SQL [closed]
  11. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  12. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  13. SQL JOIN vs IN performance?
  14. Convert varchar into datetime in SQL Server
  15. T-SQL Cast versus Convert
  16. When no ‘Order by’ is specified, what order does a query choose for your record set?
  17. What is a stored procedure?
  18. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  19. convert Excel Date Serial Number to Regular Date
  20. Partition Function COUNT() OVER possible using DISTINCT
  21. How do I create a foreign key in SQL Server?
  22. join comma delimited data column
  23. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  24. Alter user defined type in SQL Server
  25. Store multiple bit values in a single table column
  26. SQL Server equivalent to MySQL enum data type?
  27. How to correctly insert newline in nvarchar [duplicate]
  28. Using IF ELSE statement based on Count to execute different Insert statements
  29. SQL – Call Stored Procedure for each record
  30. Convert bigint to datetime

Leave a Comment