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.