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
Post a Comment