thanks for the immediate response.

Updated the expected result. Forgot to put additional information. If we aggregate the records and Col3 doesn't consists of "B" value it shouldn't be aggregated...

Thanks guys! that's definitely a good idea! Cheers!

dwain.c it works!!!!!! :Wow:

cadavre i would really appreciate it if you can walk me through on your query. the stuff and xml path are all new to me.

Thanks a...

Sorry I know it's spoon feeding already. I've exerted all efforts but cant find the right script. I was thinking to put a "NULL" value to the columns that lacks...

Cadavre (10/16/2013)

---

I don't fully understand what you actually want here, it's always easier to figure out when you supply us with DDL, readily consumable sample data and expected results based...