kapil_kk (4/17/2013)
Please help me on this...
The scenario that you have mentioned is not very clear.
It would be good if you can explain your issue with some DDL and sample data along with the expected result
That will help people understand your issues better
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/