Home Forums SQL Server 2008 T-SQL (SS2K8) days into completed weeks only RE: days into completed weeks only

  • September 11, 2012 at 7:54 am

    #1536249

    Please check if this can help you!!!

    select CAST(20.0/7 AS INT) + CASE WHEN (20%7) > 3 THEN 1 ELSE 0 END

    Regards,
    Mitesh OSwal
    +918698619998