Hello All I have an intermediate table result which looks like this
I need to transform this result set into something like this
I guess i have to use PIVOTing for the same. But im stuck in the point where i cannot use the COUNT/SUM operator inorder to get the CONTENT column.Can anyone help me with the query for achieving the result ???
Thanks in advance
answered Oct 28 '09 at 03:53 AM