Home Forums SQL Server 2005 T-SQL (SS2K5) The maximum recursion 100 has been exhausted before statement completion RE: The maximum recursion 100 has been exhausted before statement completion

  • Apologies I posted a slightly incorrect query, given your requirements. It should have:

    COUNT(*)

    in place of the:

    DATENAME(dw,date)