Hi everyone.
I have the following code:
begin
SET @CONTADOR = @CONTADOR + 1;
set @strQuery='';
set @intYDS = 0;
SET @strQUERY = 'SELECT @intYDS = ISNULL(COALESCE(YDS,0),0)'
SET @strQUERY = CONCAT(@strQuery,'FROM OPENQUERY([ORACLE],''select nvl(SUM(DEREQ.CANTIDAD),0) AS YDS
from LOGTEL.REQUISICIONES REQUI INNER JOIN LOGTEL.DET_REQUISICIONES DEREQ
ON (REQUI.CORREL_REQUISICION = DEREQ.CORREL_REQUISICION)
inner join CORS.DET_ARTICULOS_CORS art
on (requi.codigo_cor = art.codigo_cor)
WHERE REQUI.ESTADO_REQUISICION <>''ANL''
and art.codigo_articulo_cor = 1
AND REQUI.CONTROL_INTERNO = ', @control_interno_po ,' group by REQUI.CONTROL_INTERNO '');');*/
BEGIN TRY
EXEC(@strQuery);
INSERT INTO DW_MU_REPORT (ship_cancel, CUSTOMER, PO_NUMBER, WASH, CUSTOMER_ORDER,YDS, CONTROL_IN ...
Go to the complete details ...