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

  • July 11, 2014 at 9:37 am

    #1728795

    If you are wanting to ADD all the gaps together per customer per year, then my code WILL NOT work. I thought you were looking for ANY SINGLE GAP of 45 days or larger.

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura