728x90
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
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
'데이터베이스 > SQL Server' 카테고리의 다른 글
| UPDATE 문 CASE (0) | 2008.04.29 |
|---|---|
| Where 절 CASE문 사용 (0) | 2008.04.29 |
| 인덱스 최적화 팁 (0) | 2008.04.29 |
| 올바른 순위 정렬 결과를 얻으려면 (0) | 2008.04.29 |
| SQL Server 데이터베이스의 트랜잭션 로그가 예기치 않게 커지는 것을 막는 방법 (0) | 2008.04.29 |