(select name from MANAGER b where b.idx = a.adminid) as @l_manageridx=l_manageridx << 이쪽에서 오류가 나는데어떻게 고쳐야 하나요? ㅠㅠ
select
@comnm=comnm,@usernm=usernm,@tel1=tel1,@tel2=tel2,@tel3=tel3,@email=email,
@adminid=adminid,@comregno=comregno,@content=content,
(select name from MANAGER b where b.idx = a.adminid) as @l_manageridx=l_manageridx,
(select name from MANAGER b where b.idx = @manageridx) as @l_manageridx2=l_manageridx2,
@statcd=statcd,@recontactdt=recontactdt
From [REQUEST_TB] a where ridx= @intRidx
Comment 1
-
Hisory
2014.06.05 14:23
select
@comnm=comnm,@usernm=usernm,@tel1=tel1,@tel2=tel2,@tel3=tel3,@email=email,
@adminid=adminid,@comregno=comregno,@content=content,
@l_manageridx= (select top 1 name from JOB_AGENCY_REQUEST_MANAGER b where b.idx = a.adminid) ,
@l_manageridx2= (select top 1 name from JOB_AGENCY_REQUEST_MANAGER b where b.idx = @manageridx) ,
@statcd=statcd,@recontactdt=recontactdt
From [JOB_AGENCY_REQUEST_TB] a where ridx= @intRidx