</pre><BR><BR>There's a fixed, small number of different statuses (status1, ..., statusn), I want to generate a dataset with the following columns:<BR><BR>source, status1_num, status2_num, ..., ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback