작성일 : 12-06-28 19:55
|
[MsSQL] fn_Split [배열정보를 테이블로 만들기]
|
 |
|
글쓴이 :
조형래
 조회 : 3,804
|
Update LR
Set STAT = @NextLrnRebStat
, DATET = Case @NextLrnRebStat
When 'RA' Then getDate()
Else C_DATET End
, A_DATET = Case @NextLrnRebStat
When 'RC' Then getDate()
Else A_DATET End
From [Spicus].[dbo].[REBATE] As LR
Inner Join
(Select LTrim(RTrim(value)) As SEQ From SpicusUsr.fn_Split(@SelectedItems, '!@'))
As SI
On SI.SEQ = LR.SEQ
Where LR.STAT = @STAT
얼쭈 맞음
|
|
1223
