I have the following query case and it gives error

0
SELECT [DBO].[TBL_CONSUMO_PLANIF].[FEC_DTO] AS FECHA,
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14QG000',
                                   'CRE14QH000')THEN COUNT([DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE]) ELSE 0 END "CANT_MICROCREDITOS",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14QM000',
                                   'CRE14QN000',
                                   'CRE14QO000',
                                   'CRE14QP000')THEN  COUNT([DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE]) ELSE 0 END "CANT_CREDITOS_SIN_PAGARES",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14QD000',
                                   'CRE14QF000')THEN  COUNT([DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE]) ELSE 0 END "CANT_CREDITOS_CON_ABONO_LINEA_TELEFONIA",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14OX000',
                                   'CRE14OY000',
                                   'CRE14OZ000')THEN  COUNT([DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE]) ELSE 0 END "CANT_CREDITOS_CON_ABONO_LINEA_INTERNET_CONVENIO",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14RE000',
                                   'CRE14RC000',
                                   'CRE14RI000')THEN  COUNT([DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE]) ELSE 0 END "CANT_CREDITOS_CON_ABONO_LINEA_INTERNET_NO_CONVENIO",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14QG000',
                                   'CRE14QH000')THEN SUM([DBO].[TBL_CONSUMO_PLANIF].[MONTO_MM]) ELSE 0 END "MONTO_MICROCREDITOS",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14QM000',
                                   'CRE14QN000',
                                   'CRE14QO000',
                                   'CRE14QP000')THEN  SUM([DBO].[TBL_CONSUMO_PLANIF].[MONTO_MM]) ELSE 0 END "MONTO_CREDITOS_SIN_PAGARES",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14QD000',
                                   'CRE14QF000')THEN  SUM([DBO].[TBL_CONSUMO_PLANIF].[MONTO_MM]) ELSE 0 END "MONTO_CREDITOS_CON_ABONO_LINEA_TELEFONIA",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14OX000',
                                   'CRE14OY000',
                                   'CRE14OZ000')THEN  SUM([DBO].[TBL_CONSUMO_PLANIF].[MONTO_MM]) ELSE 0 END "MONTO_CREDITOS_CON_ABONO_LINEA_INTERNET_CONVENIO",
    CASE WHEN  [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14RE000',
                                   'CRE14RC000',
                                   'CRE14RI000')THEN  SUM([DBO].[TBL_CONSUMO_PLANIF].[MONTO_MM]) ELSE 0 END "MONTO_CREDITOS_CON_ABONO_LINEA_INTERNET_NO_CONVENIO"
FROM [DBO].[TBL_CONSUMO_PLANIF] 
WHERE [DBO].[TBL_CONSUMO_PLANIF].[FEC_DTO] >= '20180101'
      AND [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE] IN('CRE14QG000',
                        'CRE14QH000',
                        'CRE14QM000',
                        'CRE14QN000',
                        'CRE14QO000',
                        'CRE14QP000',
                        'CRE14QD000',
                        'CRE14QF000',
                        'CRE14OX000',
                        'CRE14OY000',
                        'CRE14OZ000',
                        'CRE14RE000',
                        'CRE14RC000',
                        'CRE14RI000') 
GROUP BY [DBO].[TBL_CONSUMO_PLANIF].[FEC_DTO], 
         [DBO].[TBL_CONSUMO_PLANIF].[ID_PRD_OPE]
ORDER BY [DBO].[TBL_CONSUMO_PLANIF].[FEC_DTO]

Returns error:

  

.Net SqlClient Data Provider: Mens. 245, Level 16, State 1, Line 1 Conversion failed when converting the value nvarchar 'CRE14QF000' to data type int.

    
asked by marco acevedo 18.01.2018 в 17:25
source

0 answers