tony.sawyer (7/17/2008)
...I can't think of a simple, elegant solution to create a variable number of columns based on data returned without resorting to some meaty dynamic sql to create a temporary table on the fly based on the core data returned and then selecting the date from that to get the output grid ...
I think your fear is justified...yet another case where the SQL Server developers ignored the good work and features of MS Access, whose transform operator did generate the summary columns dynamically based on the source data (and also allowed you to pick and choose so you could inhibit some columns and add others that were not in the data.)
I am eagerly awaiting Jeff's article!