Ok, we are just looking into a move to SQL Server 2005 (I know, a little late but...)
What I need to do is a simple cross tab query. Here is what I have:
A table with multiple columns including Sex
I need to take the query:
select Sex, COUNT(*) SexCount from MyTable group by Sex
The results are:
What I need is the following:
I have labeled the columns Column1 and Column2 because I don't know what the column names may have to be. Everything I have seen turns Male/Female into the ColumnHeader. I have seen messy stuff involving creation of temp tables, etc. My thinking is that there must be something new in 2005 that allows this to be done easily.