• the information that you have provided is not sufficient for us to understand what you want to achieve?

    can you please some more detailed information like what output you want from those sample data/....

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/