Home Forums SQL Server 2005 SQL Server 2005 General Discussion Need help on creating SQL statement for deriving Consecutive worked days. RE: Need help on creating SQL statement for deriving Consecutive worked days.

  • December 13, 2012 at 2:25 am

    #1568201

    10e5x (12/13/2012)

    Hi lyn,

    I tested your solutions and it works. However they keep prompt me "the OVER SQL constructs or statements is not supported". I just ignored that. Do u have any idea whats that?

    And ya i am sry, i did not asked for an SSIS solution and i do know this is an SQL job. However i am asked to see if i can do this in SSIS, which i am researching for it now. So asking for ur opinion.

    Anyway thanks for replying.

    Thanks,

    10e5x

    P.S I joined 3 forums to learn on SQL server and this forum is the best among all. Fastest reply rate with accuracy. THANKS!!!

    First, look with eye, try spelling my name correctly, it is spelled with 2 n's not one.

    Second, what version of SQL Server are you running?

    Third, what is the full error message you are getting? The dense_rank function has been available since SQL Server 2005 and should work without giving you any error messages.