• Muhanned Maayeh-445298 (7/19/2016)


    J Livingston SQL (7/19/2016)


    Nice solution 🙂 thank you I will have to try out with our different conditions but looks very promising

    If you have "different conditions" then why did you not post them in the first place?

    No worries conditions are the business cases faced on scheduling itself; not practical to include this in a post as this will be too complex and numerous to discuss. I just needed initially to understand how to re-look at the data in a less complex and efficient manner unlike in a previous more complex method that was implemented. Again, I appreciate the reply and help.

    faie enough...hope you get it sorted successfully

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day