Sybase 9 를 사용하고 있는데요..
이번에 DB를 Sybase로 변경을 하려고 하는데 쿼리 수정이 잘 안 되네요..
도움 부탁드립니다..
SELECT B.RPS_PROD_CODE
, CASE WHEN 0 <= ('20070302' - C.SEL_DATE) AND ('20070302' - C.SEL_DATE) <= 79 THEN '1'
WHEN 79 < ('20070302' - C.SEL_DATE) AND ('20070302' - C.SEL_DATE) <= 86 THEN '2'
WHEN 86 < ('20070302' - C.SEL_DATE) AND ('20070302' - C.SEL_DATE) <= 93 THEN '3'
WHEN 93 < ('20070302' - C.SEL_DATE) AND ('20070302' - C.SEL_DATE) <= 100 THEN '4'
ELSE '0'
END AS SWEEK
, SUM(C.SEL_QTY)
FROM SRATSADE A, SBBVPROD B, SRATSAMA C
WHERE C.SEL_AREA_CODE = '00581433'
AND A.SEL_NO = A.SEL_NO
AND A.PROD_CODE = B.PROD_CODE
AND C.SEL_CHK IN ('1', '2')
GROUP BY B.RPS_PROD_CODE
, CASE WHEN 0<=('20070302'-SEL_DATE) AND ('20070302'-SEL_DATE)<=79 THEN '1'
WHEN 79<('20070302'-SEL_DATE) AND ('20070302'-SEL_DATE)<=86 THEN '2'
WHEN 86<('20070302'-SEL_DATE) AND ('20070302'-SEL_DATE)<=93 THEN '3'
WHEN 93<('20070302'-SEL_DATE) AND ('20070302'-SEL_DATE)<=100 THEN '4'
ELSE '0'
END
|