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,'')