Turns out I was able to clear everything out by disabling replication (luckily it was on the test server ) and then re-enabling it.

I...

Basically what I did was build a sql string with a several sections:

1. Header

2. column list from joins

3. FROM section

4. SELF JOINS from variables I wanted to transpose

5. WHERE clause

Sections...

Thanks for all the helpful suggestions. 

I was able to accomplish what I need by using dynamic sql to generate the required number of self joins - each of which...

Using case statements won't work unless I can dynamically generate the number of case statements since the table width may vary.

Ken- basically what i want to do is transpose row...