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

  • Hi autoexcrement!

    Just to make sure I'm on the right path. This will not be a 2 or 3 step solution, right?

    You saw my sample data and it is very convoluted.

    I have like 20 steps until now including what you gave and still cannot see that I am doing the right thing here. 🙁

    Getting a bit depressed that I cannot get this to work properly!!

    Thank you so much for the explanation though, it was much clearer than what I've come across online.

    Tammy