sturner (8/2/2013)
insert the pivot into a temp table first, then select from that with you roll-up totals.
That still presents the same problem. Even if I put it in a temp table first, I have no idea what the column names are until the temp table is created. After I create that table how do I figure out what the column names are?