SELECT
ISNULL(TMPL_NO,'') AS TMPL_NO,
COUNT(SUP_NO) AS APP_COUNT,
SUM(CASE WHEN @FAVER ='P' THEN ISNULL(ACC_COUNT,0)
WHEN @FAVER ='S' THEN ISNULL(ACC_COUNT_SPCL,0)
ELSE ISNULL(ACC_COUNT,0) + ISNULL(ACC_COUNT_SPCL,0) END ) ACC_COUNT ,
--가입시 최초
SUM(CASE WHEN @FAVER ='P' THEN ISNULL(BASIC_Pblc_COUNT,0)
WHEN @FAVER ='S' THEN ISNULL(BASIC_Spcl_COUNT,0)
ELSE ISNULL(BASIC_Pblc_COUNT,0) + ISNULL(BASIC_Spcl_COUNT,0) END ) BASIC_Pblc_COUNT
FROM TBLMEMBER
WHERE HCODE LIKE @HCODE + '%'
AND CASE WHEN @FAVER ='P' THEN PBLCYN
WHEN @FAVER ='S' THEN SPCLYN ELSE 'Y' END = 'Y'
AND REG_DT BETWEEN @S_DT AND @E_DT
AND (IF @DIV_CODE <>'' then DIV_CODE= @DIV_CODE end if) --------이거 해결해야되는데 어떻게 하면 해결할수 있을까요??
DIV_CODE 값이 '' 이 아니면 DIV_CODE에 DIV_CODE 값이 들어가고 ''이면 전체값이 나와야되는데 알려주세용~~
GROUP BY ISNULL(TMPL_NO,'')
Comment 3
-
아수라발발타
2014.06.18 14:48
완전 대단하십니다.. NULL 값도 같이 검색되는 방법도 있나요??
-
AND ISNULL(DIV_CODE, '') = CASE WHEN @DIV_CODE <> '' THEN @DIV_CODE ELSE ISNULL(DIV_CODE, '') END
AND DIV_CODE = CASE WHEN @DIV_CODE <> '' THEN @DIV_CODE ELSE DIV_CODE END
아... 근데 DIV_CODE가 NULL인거는 검색되지 않습니다.