I would ideally like to display some data in an ASP front end in a Pivot Table style Resultset.
I would like to put my Columns into the first column of a table, then the fields in the second column and the Values in the next.
Red | Bucket | 22
Red | Spade | 25
Blue | Bucket | 23
Blue | Spade | 24
Red | Blue
Bucket 22 | 23
Spade 25 | 24
I have a variable number of fields, that change fairly frequently.
Apparently SQL Server 2000 doesn't support this type of thing. I was hoping with ASP I could maybe do it?