Sduty/MS-SQL
조건별 실행
돌멘
2014. 6. 20. 08:34
AND CASE WHEN @CHK = '1' THEN A.CONTRACT_DT
WHEN @CHK = '2' THEN A.ORDER_COM_DT
WHEN @CHK = '3' THEN A.PERIOD_DT
END BETWEEN @STR_DT AND @END_DT