Breaking News: Grepper is joining You.com. Read the official announcement!

The statement terminated. The maximum recursion 500 has been exhausted before statement completion

Selfish Sheep answered on November 16, 2023 Popularity 4/10 Helpfulness 2/10

answer The statement terminated. The maximum recursion 500 has been exhausted before statement completion

The statement terminated. The maximum recursion 500 has been exhausted before statement completion

Comment

DECLARE @STARTDATE datetime; 
DECLARE @EntDt datetime; 
set @STARTDATE = '01/01/2009';  
set @EntDt = '12/31/2009'; 
declare @dcnt int; 
;with DateList as   
 (   
    select @STARTDATE DateValue   
    union all   
    select DateValue + 1 from    DateList      
    where   DateValue + 1 < convert(VARCHAR(15),@EntDt,101)   
 )   
  select count(*) as DayCnt from (   
  select DateValue,DATENAME(WEEKDAY, DateValue ) as WEEKDAY from DateList
  where DATENAME(WEEKDAY, DateValue ) not IN ( 'Saturday','Sunday' )     
  )a
option (maxrecursion 365);

Popularity 4/10 Helpfulness 2/10 Language whatever

Source: stackoverflow.com

Tags: completion recursion whatever

Link to this answer
Share Copy Link