• I am not sure what you mean by 35 combinations and your description is not detailed enough either.

    Your request doesn't seem too complex and I am sure you will get a quick response if you provide us the below mentioned things.

    1. DDL statements of the table(s) involved

    2. Some sample data to populate the table(s), at least for 2 - 3 dates

    3. Expected results in an easy to understand form

    This will help us understand your question better and also test any solutions before posting it to you.

    You can have a look at the link in my signature if you are not sure on how to do this.


    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/