case when

[chuchufuentes]

Esto no trabaja, por favor alquien tiene una mejor idea

select
CASE @PagoDesc
WHEN 'CA' THEN select @Total_PAGOEFECTIVO = @Total_PAGOEFECTIVO + @montotemp
WHEN 'CC' THEN select @Total_PAGOCREDITO = @Total_PAGOCREDITO + @montotemp
WHEN 'EX' THEN select @Total_PAGOCANJE = @Total_PAGOCANJE + @montotemp
WHEN 'MC' THEN select @Total_PAGOMCO = @Total_PAGOMCO + @montotemp
WHEN 'FD' THEN select @Total_PAGOFACTDIRECT = @Total_PAGOFACTDIRECT + @montotemp
WHEN 'AF' THEN select @Total_PAGOAFILIACION = @Total_PAGOAFILIACION + @montotemp
WHEN 'EO' THEN select @Total_PAGOCANJEOTRAS = @Total_PAGOCANJEOTRAS + @montotemp
ELSE select @Total_PAGOMCOOTRAS = @Total_PAGOMCOOTRAS + @montotemp
END

Gracias