> > There are times when I would love to be able to pivot data on the
> > server, to further process the data an SP.
>
> SP cannot process queries with unknown number of fields. Neither client
> part, BTW.

Who said that the number of columns/fields was unknown?

I could want to deal with a pivot of a known/expected 'width' within my SP.


As for the client access, I agree that the depending on the pivot definition, the number of columns could be unknown.

But this would be an argument to create API methods which would have the number of columns determined by dimensions of the result set, not fixed during the call.

This is not a valid reason to say that the pivot can't/should not be created on server.


Sean