I need help with the following
I have a few ideas but was wondering if there was an easier way
The following code gives me
Compliance 23 24 19 8 etc.......
I want it to be in this format
Compliance
23
24
19
8
In other words compliance should be a column and not a row.
Insert into #TotalledDHours (DiscCategory, month1, month2, month3, month4, month5, month6, month7, month8, month9, month10, month11, month12)
Select DiscCategory, sum(month1), sum(month2), sum(month3), sum(month4), sum(month5), sum(month6), sum(month7) , sum(month8), sum(month9), sum(month10), sum(month11), sum(month12)
from #TempCategorySummed
Group by DiscCategory
Order by DiscCategory
Start Free Trial