Re: Interesting data transposition problem

puneet.bansal_at_wipro.com wrote:
> This is fine but how do I handle this when col1 has not just X and Y
> but many values say A,B, C....

You need pivot operator in order to transform values into column headers. Pivot operator is available in MS Server 2005 and other vendors will catch up someday too.

http://www.vldb.org/conf/2004/IND1P2.PDF Received on Fri Jun 10 2005 - 12:46:55 CDT