Forums
This topic is locked
Old Sschool cross tab queries
Posted 19 Feb 2009 20:47:21
1
has voted
19 Feb 2009 20:47:21 Matt Bristow posted:
I need to create an old school type cross tab queryI have found a pretty good example here
weblogs.sqlteam.com/jeffs/articles/5174.aspx
and with as bit of shoe horning I have managed to get it to do what I want with the exception that I also need to total all rows and columns.
firstly is there a better way of doing this, this site the final page is to be used on cannot use any plugins at all so flex is out.
secondly anyone have any ideas how to add a count function to both rows and columns in this example?