ChrisM@Work (1/30/2014)
Can you post up some sample data, Kapil? Showing multiple rows per key? Obfuscate if necessary, but it really would be very useful to see it.
I already posted a scenario with some dummy data in my first post....
Isn't that worked for you?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/