</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, ..., ...

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 ...