sql - Recursion with CTE not working -


with cte (     select convert(varchar(100), 'milestone')  name, casedependencymilestone.templatemilestoneid,   casedependencymilestone.dependenttemplatemilestoneid,                            casedependencymilestone.dependenttemplatetaskid,milestonetime, casetemplatemilestone.projectedenddate             casetemplatemilestone inner join                            casedependencymilestone on casetemplatemilestone.casetemplatemilestoneid = casedependencymilestone.templatemilestoneid         (casetemplatemilestone.casetimelineid = @casetimelineid ,      templatemilestoneid=@milestoneid) --and casedependencymilestone.dependenttemplatemilestoneid<>0     union     select  convert(varchar(100), 'milestone') name, casedependencymilestone.templatemilestoneid, casedependencymilestone.dependenttemplatemilestoneid,                            casedependencymilestone.dependenttemplatetaskid,c.milestonetime, c.projectedenddate                            casedependencymilestone inner join                             cte on casedependencymilestone.templatemilestoneid=cte.dependenttemplatemilestoneid                            inner join casetemplatemilestone c on c.casetemplatemilestoneid=casedependencymilestone.templatemilestoneid                            c.casetimelineid = @casetimelineid     union     select  convert(varchar(100),'task') name, casedependencytask.templatetaskid, casedependencytask.dependenttemplatemilestoneid,                            casedependencytask.dependenttemplatetaskid,tasktime, t.projectedenddate                            casedependencytask inner join                             cte on casedependencytask.templatetaskid=cte.dependenttemplatetaskid                            inner join casetemplatetask t  on t.casetemplatetaskid=casedependencytask.templatetaskid                          t.casetimelineid = @casetimelineid  )  select * cte option(maxrecursion 0) 

but not getting result. function running 5 minutes.


Comments