Stack the sums for each each month adding month abreviation and grouping by exposure and category. SQL is more flexible than sas proc summary, but is slower. Suppose you want the sum of cubes instead ...
I have a SQL Script that produces the following pivot query:<BR><BR> <pre class="ip-ubbcode-code-pre">SELECT ClientID, FirstName, LastName, SSN, 05/01/2009],[05/02 ...
CheckListItems CheckListItemId ItemName 1 name1 2 name2 3 name3 4 name4 5 name5 ... I can't seem to get the PIVOT syntax correct- it has to be dynamic as I don't know all the ItemNames (and there ...
Transact-SQL reference for PIVOT and UNPIVOT relational operators. Use these operators on SELECT statements to change a table-valued expression into another table.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results