enrique_aeo
asked on
option (MAXRECURSION 1): The maximum recursion 1 has been exhausted before statement completion.
i have this query
;with CTE(Num)
as
(
select 1
union all
select Num + 1
from CTE
where Num <= 100
)
insert into dbo.Data(ADate)
select DATEADD(day,-Num % 365, GetDate())
from CTE
option (MAXRECURSION 0)
go
when option (MAXRECURSION 0) is OK
BUT
when option (MAXRECURSION 1) i HAVE THIS ERROR
Msg 530, Level 16, State 1, Line 1
The statement terminated. The maximum recursion 1 has been exhausted before statement completion.
;with CTE(Num)
as
(
select 1
union all
select Num + 1
from CTE
where Num <= 100
)
insert into dbo.Data(ADate)
select DATEADD(day,-Num % 365, GetDate())
from CTE
option (MAXRECURSION 0)
go
when option (MAXRECURSION 0) is OK
BUT
when option (MAXRECURSION 1) i HAVE THIS ERROR
Msg 530, Level 16, State 1, Line 1
The statement terminated. The maximum recursion 1 has been exhausted before statement completion.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
but if it would help a good example regarding use of MAXRECURSION
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
;with CTE(Num)
as
(
select 1
union all
select Num + 1
from CTE
where Num <= 100
)
insert into dbo.Data(ADate)
select DATEADD(day,-Num % 365, GetDate())
from CTE
option (MAXRECURSION 150)
go
With the 'where I'm telling you to run 100 times, with MAXRECURSION tell him to run up to 150 times, but it does not, that is, I expected to run 50 times, and should it work?