Can you pivot a results set inside a stored procedure before it gets to the client machine.

In the particular data model that I am working with each column in a row is a row in this data model. So what I want to do is select all of the columns and then pivot them back to look like rows. Can this be done in a stored procedure.

Thanks


to send reply email take off the .nospam