• We would definitely need more information to help you

    Please explain the issue a bit more and also provide the DDL of the tables involved, some sample data and the expected results based on the sample data

    If you are not sure about how to do this, please check the link in my signature


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/