I did it as below and that seems to work.

...

Thanks. I did not think this was necessary info, so I did not mention it earlier.

But this query is an ASP.NET app where the user will enter from and to...

Thanks - I only want records from Jan. 2011 thru Jan. 2012. So not sure your solution would work.

The data is from a linked server over which I have...

Thanks Jeff, I need them to be in columns - a table actually.

Tina

Thanks, I will check out the link.

I saw various solutions but most of them are not applicable in my case since the id and subid columns have unique values...

The table is as below

[id] [subid] [pct]

abc w 10

abc e 20

abc g 70

def...