Home Forums SQL Server 2005 T-SQL (SS2K5) finding gaps between termination date and next enrollment date and filter by gap >= 45 days for year 2013 RE: finding gaps between termination date and next enrollment date and filter by gap >= 45 days for year 2013

  • Good morning, Lynn!!! 😀

    I'm happy to say it works like a charm!!!!

    Your explanation is also really useful so I can understand what is going on.

    I have a final question, what are you using the dayslapsed for?

    I see it's the different between numdays and daysinyear, but is it being used or is this an extra check?

    Thanks a lot for all your help with my issue!!!

    Tammy