SQL Unpivot multiple columns Data

by

An easier way to unpivot the data would be to use a CROSS APPLY to unpivot the columns in pairs:

select vendorid, orders, orders1
from pvt1
cross apply
(
  select emp1, sa union all
  select emp2, sa1
) c (orders, orders1);

See SQL Fiddle with Demo. Or you can use CROSS APPLY with the VALUES clause if you don’t want to use the UNION ALL:

select vendorid, orders, orders1
from pvt1
cross apply
(
  values 
    (emp1, sa),
    (emp2, sa1)
) c (orders, orders1);

See SQL Fiddle with Demo

More Related Contents:

  1. Unpivot with column name
  2. How to delete 0 values but not blanks from a column in SQL Server 2008 programming?
  3. Efficiently convert rows to columns in sql server
  4. SQL Server : Columns to Rows
  5. Is there a way to access the “previous row” value in a SELECT statement?
  6. What this query does to create comma delimited list SQL Server?
  7. SQL Server – Return value after INSERT
  8. SQL NVARCHAR and VARCHAR Limits
  9. SQL transpose full table
  10. Select statement to find duplicates on certain fields
  11. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  12. SQL Server : dynamic pivot over 5 columns
  13. How to select the last record of a table in SQL?
  14. How to find current transaction level?
  15. How to create table using select query in SQL Server?
  16. Check for file exists or not in sql server?
  17. Group DateTime into 5,15,30 and 60 minute intervals
  18. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  19. SQL SERVER: Get total days between two dates
  20. Store multiple bit values in a single table column
  21. Which SQL query is faster? Filter on Join criteria or Where clause?
  22. SQL Server equivalent to MySQL enum data type?
  23. UPDATE and REPLACE part of a string
  24. Improve SQL Server query performance on large tables
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  27. How to execute a stored procedure inside a select query
  28. Single or multiple databases
  29. How to Select Every Row Where Column Value is NOT Distinct
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment