Home Forums SQL Server 2008 T-SQL (SS2K8) Calculate number of days missed per term RE: Calculate number of days missed per term

  • April 3, 2013 at 9:13 am

    #1603241

    Chris,

    I substituted this line in your code with this and it worked.

    --AND a.DateABS BETWEEN ISNULL(x.StartDate,'19000101') AND t.EndDate

    AND a.DateABS BETWEEN ISNULL(@FirstDay,'19000101') AND t.EndDate

    @FirstDay was set to '2012-08-14'

    This got me the desired results for the test data I supplied. Now I need to test against Prod data.

    Thanks again!!

    Sqlraider