with cte_edms( depthno, tlk_seq, hnk_tlk_seq, cmtscont, nLevel)
as
(
select depthno, tlk_seq, hnk_tlk_seq, cmtscont, 1 as nLevel from kisbns..s_kb015 where tlk_seq = 164
union all
select a.depthno, a.tlk_seq, a.hnk_tlk_seq, a.cmtscont, nLevel + 1 from kisbns..s_kb015 a, cte_edms b where a.tlk_seq = b.hnk_tlk_seq
)
select depthno, tlk_seq, hnk_tlk_seq, cmtscont from cte_edms order by nLevel
일케 쓰닌깐
Incorrect syntax near the keyword 'with'. 라는 오류메시지가 나오네요 어케 햐야 할지..........프로시저도 사용을 못하고 미치 겟습니다.. |