Hi,

If this is a one time type of thing, it's a pretty straightforward to do in excel using PivotTables. Like you, I will be curious to see the "T-SQL"...