컴퓨토피아

UPDATE MATBUY_LIST SET
ReceiptDate = CASE @pStatusCHK
When 'S' Then @pOrderDate
ELSE ReceiptDate
End,
OrderDate = @pOrderDate ,
Mention1 = @pMention1 ,
StatusCHK = @pStatusCHK ,
SysUser = @pRegUser ,
SysDate = GETDATE()
WHERE BUYNO = @pBUYNO 

(Select PaperNum, DeptCD, EmployeeID
From DECIDE_APPR
Where EmployeeID = @pDeptCD
And ApplyCHK LIKE CASE @pStatusCHK
WHEN '0' THEN ''
ELSE RTRIM(@pStatusCHK) + '%'
END ) T2 

Select T1.*,
T2.BudgetCD, (T2.OutGubun + ' ' + T2.BudgetName) AS BudgetName
From SBN06 T1, dbo.fn_GET_BudgetCD( @pInstitutionCD , '3' ) T2
Where InstitutionCD = @pInstitutionCD
And T1.BasisDT Between @pSDate And @pEDate
And T1.BudgetCDID = T2.BudgetCDID
Order By
CASE WHEN @pGubun = 'DAY' THEN T1.BasisDT END ,
CASE WHEN @pGubun = 'CODE' THEN T2.BudgetCD END
, T1.ExpenditureNum, T2.BudgetCD