How do you pivot tables in SQL server? Was it a new feature in the 2005 version?
I've used a crosstab stored procedure I found on t'intertron before but it was quite fiddly.
yup its new...
http://www.devx.com/dbzone/Article/28165
Ooo, groovey. I shall bear it in mind when I work somewhere that have finally upgraded!
you don't have your own SQL Server installations?
Ooo, groovey. I shall bear it in mind when I work somewhere that have finally upgraded!