Transpose Sql Result Set

I have data in the following format: Machine | week_end | widgets A | 05-26-2013 | 5 B | 05-26-2013 | 4 A | 04-01-2013 | 6 B | 04-01-2013 | 0 I want my r

Solution 1:

You will need to do some research on the SQL PIVOT function. It will allow you to turn rows into columns. This should be what you are looking for, once you find out how to apply it.

Check out this link: Using PIVOT and UNPIVOT