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 4:59 am

    #1728679

    for clarification....what would you expect for these :

    INSERT INTO [nj_members] VALUES('abc','123',2013-01-01,2013-01-31)

    INSERT INTO [nj_members] VALUES('abc','123',2013-02-14,2013-03-31)

    INSERT INTO [nj_members] VALUES('abc','123',2013-04-14,2013-04-30)

    INSERT INTO [nj_members] VALUES('abc','123',2013-05-14,2013-12-31)

    INSERT INTO [nj_members] VALUES('xyz','999',2013-01-01,2013-06-30)

    INSERT INTO [nj_members] VALUES('xyz','999',2013-08-01,2013-11-30)

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