Skip to content

Instantly share code, notes, and snippets.

@rparatodxs

rparatodxs/venta_preliminar.txt

Last active March 1, 2019 11:57
Show Gist options
  • Save rparatodxs/4227d423aecee283ccc2dda6b1f5a28d to your computer and use it in GitHub Desktop.
Save rparatodxs/4227d423aecee283ccc2dda6b1f5a28d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
venta_preliminar.txt
#RODBC::sqlQuery(channel = myconn,query = "DROP TABLE oriP")
#RODBC::sqlQuery(channel = myconn,query = "DROP TABLE recP")
#RODBC::sqlQuery(channel = myconn,query = "DROP TABLE CodOri_2019P")
#RODBC::sqlQuery(channel = myconn,query = "DROP TABLE CodRec_2019P")
#RODBC::sqlQuery(channel = myconn,query = "DROP TABLE CuentaOrigP")
#RODBC::sqlQuery(channel = myconn,query = "DROP TABLE CuentaRectP")
#/*Tiempo de ejecución OCT2019 00:40:34*/
sqlQuery(channel = myconn,query = "
SELECT Año_trib, Rut_ficticio, COUNT(Orden) AS Cuenta
INTO oriP
FROM DEEC_4.dbo.F292019_Preliminar_Originales_Id
GROUP BY Año_trib, Rut_ficticio HAVING (Año_trib = 2019)
")
sqlQuery(channel = myconn,query = "
SELECT Año_trib, Rut_ficticio, COUNT(Orden) AS Cuenta
INTO recP
FROM DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id
GROUP BY Año_trib, Rut_ficticio HAVING (Año_trib = 2019)
")
sqlQuery(channel = myconn,query = "
ALTER TABLE oriP ADD Origen nvarchar(4)
ALTER TABLE recP ADD Origen nvarchar(4)
")
sqlQuery(channel = myconn,query = "
UPDATE oriP SET Origen = N'ORI' WHERE (Origen IS NULL)
UPDATE recP SET Origen = N'REC' WHERE (Origen IS NULL)
")
sqlQuery(channel = myconn,query = "
INSERT INTO oriP (Año_trib, Rut_ficticio, Cuenta, Origen)
SELECT Año_trib, Rut_ficticio, Cuenta, Origen
FROM recP
")
sqlQuery(channel = myconn,query = "
SELECT Rut_ficticio INTO TotalULP FROM oriP
GROUP BY Rut_ficticio
")
sqlQuery(channel = myconn,query = "
ALTER TABLE TotalULP ADD Orig int;
ALTER TABLE TotalULP ADD Rect int;
ALTER TABLE TotalULP ADD Total_Decl int;
ALTER TABLE TotalULP ADD Observacion varchar (50);
")
sqlQuery(channel = myconn,query = "
UPDATE TotalULP SET Orig = oriP.Cuenta FROM TotalULP INNER JOIN oriP ON TotalULP.Rut_ficticio = oriP.Rut_ficticio
WHERE (oriP.Origen = N'ORI')
")
sqlQuery(channel = myconn,query = "
UPDATE TotalULP SET Rect = oriP.Cuenta FROM TotalULP INNER JOIN oriP ON TotalULP.Rut_ficticio = oriP.Rut_ficticio
WHERE (oriP.Origen = N'REC')
")
sqlQuery(channel = myconn,query = "
UPDATE TotalULP
SET Total_Decl = ISNULL(Orig,0) + ISNULL(Rect,0)
")
sqlQuery(channel = myconn,query = "
UPDATE TotalULP SET Observacion = [02_Final_fic].Tipo
FROM TotalULP INNER JOIN [02_Final_fic] ON TotalULP.Rut_ficticio = [02_Final_fic].Rut_ficticio_prueba
")
sqlQuery(channel = myconn,query = "
SELECT Observacion, COUNT(Rut_ficticio) AS UL, SUM(Orig) AS Orig, SUM(Rect) AS Rect, SUM(Total_Decl) AS Total_Decl
FROM TotalULP
GROUP BY Observacion
")
sqlQuery(channel = myconn,query = "
SELECT Rut_ficticio, Orig, Rect, Total_Decl, Observacion
FROM TotalULP WHERE (Observacion = 'EJERCICIO DE PRUEBA')
")
sqlQuery(channel = myconn,query = "
SELECT DEEC_4.dbo.F292019_Preliminar_Originales_Id.Rut_ficticio, DEEC_4.dbo.F292019_Preliminar_Originales_Id.Mes_trib, DEEC_4.dbo.F292019_Preliminar_Originales_Id.Año_trib,
DEEC_4.dbo.F292019_Preliminar_Originales_Id.Procedencia, DEEC_4.dbo.F292019_Preliminar_Originales_Id.FechaPresentacion, DEEC_4.dbo.F292019_Preliminar_Originales_Id.Mes_dato,
DEEC_4.dbo.F292019_Preliminar_Originales_Id.Orden, DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo, DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Valor,
DEEC_4.dbo.F292019_Preliminar_Originales_Id.Folio, DEEC_4.dbo.F292019_Preliminar_Originales_Id.FechaProceso
INTO CodOri_2019P
FROM DEEC_4.dbo.F292019_Preliminar_Originales_Id INNER JOIN
DEEC_4.dbo.F292019_Preliminar_Originales_Datos ON DEEC_4.dbo.F292019_Preliminar_Originales_Id.Mes_dato = DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Mes_dato AND
DEEC_4.dbo.F292019_Preliminar_Originales_Id.Orden = DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Orden
WHERE (DEEC_4.dbo.F292019_Preliminar_Originales_Id.Año_trib = 2019) AND ((DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 20 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 142 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 587 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 720 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 732 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 502 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 111 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 513 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 108 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 510 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 709 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 112 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 501 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 152 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 529 OR
DEEC_4.dbo.F292019_Preliminar_Originales_Datos.Codigo = 759))
")
sqlQuery(channel = myconn,query = "
SELECT DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Rut_ficticio, DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Mes_trib, DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Año_trib,
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Procedencia, DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.FechaPresentacion, DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Mes_dato,
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Orden, DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo, DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Valor,
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Folio, DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.FechaProceso
INTO CodRec_2019P
FROM DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id INNER JOIN
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos ON DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Mes_dato = DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Mes_dato AND
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Orden = DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Orden
WHERE (DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Id.Año_trib = 2019) AND ((DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 20 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 142 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 587 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 720 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 732 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 502 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 111 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 513 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 108 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 510 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 709 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 112 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 501 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 152 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 529 OR
DEEC_4.dbo.F292019_Preliminar_Rectif_Originales_Datos.Codigo = 759))
")
sqlQuery(channel = myconn,query = "
ALTER TABLE CodOri_2019P ADD Origen nvarchar(4)
ALTER TABLE CodRec_2019P ADD Origen nvarchar(4)
")
sqlQuery(channel = myconn,query = "
ALTER TABLE CodOri_2019P ADD Tipo nvarchar(5)
ALTER TABLE CodRec_2019P ADD Tipo nvarchar(5)
")
sqlQuery(channel = myconn,query = "
UPDATE CodOri_2019P SET Origen = N'ORI' WHERE (Origen IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE CodRec_2019P SET Origen = N'REC' WHERE (Origen IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE CodOri_2019P SET Tipo = N'PRELI' WHERE (Tipo IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE CodRec_2019P SET Tipo = N'PRELI' WHERE (Tipo IS NULL)
")
sqlQuery(channel = myconn,query = "
INSERT INTO CodOri_2019P (Rut_ficticio, Mes_trib, Año_trib, Procedencia, FechaPresentacion, Mes_dato, Orden, Codigo, Valor, Folio, FechaProceso, Origen, Tipo)
SELECT Rut_ficticio, Mes_trib, Año_trib, Procedencia, FechaPresentacion, Mes_dato, Orden, Codigo, Valor, Folio, FechaProceso, Origen, Tipo
FROM CodRec_2019P
")
sqlQuery(channel = myconn,query = "
SELECT Tipo, Origen, Rut_ficticio, Mes_trib, Año_trib, Procedencia, FechaPresentacion, Mes_dato, Orden, Folio, FechaProceso
INTO PanelMensualP
FROM CodOri_2019P
GROUP BY Tipo, Origen, Rut_ficticio, Mes_trib, Año_trib, Procedencia, FechaPresentacion, Mes_dato, Orden, Folio, FechaProceso
")
sqlQuery(channel = myconn,query = "
ALTER TABLE PanelMensualP ADD cod20 float;
ALTER TABLE PanelMensualP ADD cod108 float;
ALTER TABLE PanelMensualP ADD cod111 float;
ALTER TABLE PanelMensualP ADD cod112 float;
ALTER TABLE PanelMensualP ADD cod142 float;
ALTER TABLE PanelMensualP ADD cod152 float;
ALTER TABLE PanelMensualP ADD cod501 float;
ALTER TABLE PanelMensualP ADD cod502 float;
ALTER TABLE PanelMensualP ADD cod510 float;
ALTER TABLE PanelMensualP ADD cod513 float;
ALTER TABLE PanelMensualP ADD cod529 float;
ALTER TABLE PanelMensualP ADD cod587 float;
ALTER TABLE PanelMensualP ADD cod709 float;
ALTER TABLE PanelMensualP ADD cod720 float;
ALTER TABLE PanelMensualP ADD cod732 float;
ALTER TABLE PanelMensualP ADD cod759 float;
ALTER TABLE PanelMensualP ADD Seleccion nvarchar(50);
ALTER TABLE PanelMensualP ADD Criterio nvarchar(100);
ALTER TABLE PanelMensualP ADD Caso_mensual nvarchar(50);
ALTER TABLE PanelMensualP ADD Venta_mensual float;
ALTER TABLE PanelMensualP ADD Suma_codigos float;
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod20 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 20) AND (PanelMensualP.cod20 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod108 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 108) AND (PanelMensualP.cod108 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod111 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 111) AND (PanelMensualP.cod111 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod112 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 112) AND (PanelMensualP.cod112 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod142 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 142) AND (PanelMensualP.cod142 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod152 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 152) AND (PanelMensualP.cod152 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod501 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 501) AND (PanelMensualP.cod501 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod502 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 502) AND (PanelMensualP.cod502 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod510 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 510) AND (PanelMensualP.cod510 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod513 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 513) AND (PanelMensualP.cod513 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod529 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 529) AND (PanelMensualP.cod529 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod587 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 587) AND (PanelMensualP.cod587 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod709 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 709) AND (PanelMensualP.cod709 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod720 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 720) AND (PanelMensualP.cod720 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod732 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 732) AND (PanelMensualP.cod732 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET cod759 = CodOri_2019P.Valor
FROM PanelMensualP INNER JOIN CodOri_2019P ON PanelMensualP.Rut_ficticio = CodOri_2019P.Rut_ficticio AND PanelMensualP.Mes_dato = CodOri_2019P.Mes_dato AND
PanelMensualP.Orden = CodOri_2019P.Orden AND PanelMensualP.Folio = CodOri_2019P.Folio AND PanelMensualP.Mes_trib = CodOri_2019P.Mes_trib
WHERE (CodOri_2019P.Codigo = 759) AND (PanelMensualP.cod759 IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE [PanelMensualP]
SET Venta_mensual = ISNULL(cod20,0) + ISNULL(cod142,0) + ISNULL(cod587,0) + ISNULL(cod720,0) + ISNULL(cod732,0) + (((ISNULL(cod108,0) +ISNULL(cod502,0) + ISNULL(cod111,0) + ISNULL(cod112,0) +ISNULL(cod513,0) - ISNULL(cod510,0) - ISNULL(cod709,0) +ISNULL(cod759,0))+ ISNULL(cod501,0))/0.19) +(ISNULL(cod152,0) * 10) + ISNULL(cod529,0)
")
sqlQuery(channel = myconn,query = "
UPDATE [PanelMensualP]
SET Suma_codigos = ISNULL(cod20,0) + ISNULL(cod142,0) + ISNULL(cod587,0) + ISNULL(cod720,0) + ISNULL(cod732,0) + ISNULL(cod108,0) + ISNULL(cod502,0) + ISNULL(cod111,0) + ISNULL(cod112,0) + ISNULL(cod513,0) + ISNULL(cod510,0) + ISNULL(cod709,0) + ISNULL(cod501,0) + ISNULL(cod152,0) + ISNULL(cod529,0) + ISNULL(cod759,0)
")
sqlQuery(channel = myconn,query = "
SELECT Rut_ficticio, Mes_trib INTO RutF_MesTP
FROM PanelMensualP GROUP BY Rut_ficticio, Mes_trib
")
sqlQuery(channel = myconn,query = "
ALTER TABLE RutF_MesTP ADD Original int;
ALTER TABLE RutF_MesTP ADD Rectificatoria int;
ALTER TABLE RutF_MesTP ADD Total_Decl int;
ALTER TABLE RutF_MesTP ADD Caso_mensual nvarchar (50);
")
sqlQuery(channel = myconn,query = "
SELECT Origen, Rut_ficticio, Mes_trib, COUNT(Rut_ficticio) AS Expr1
INTO CuentaOrigP FROM PanelMensualP
GROUP BY Rut_ficticio, Mes_trib, Origen
HAVING (Origen = N'ORI')
")
sqlQuery(channel = myconn,query = "
SELECT Origen, Rut_ficticio, Mes_trib, COUNT(Rut_ficticio) AS Expr1
INTO CuentaRectP FROM PanelMensualP
GROUP BY Rut_ficticio, Mes_trib, Origen
HAVING (Origen = N'REC')
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Original = CuentaOrigP.Expr1
FROM CuentaOrigP INNER JOIN RutF_MesTP ON CuentaOrigP.Rut_ficticio = RutF_MesTP.Rut_ficticio AND CuentaOrigP.Mes_trib = RutF_MesTP.Mes_trib
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Rectificatoria = CuentaRectP.Expr1
FROM CuentaRectP INNER JOIN RutF_MesTP ON CuentaRectP.Rut_ficticio = RutF_MesTP.Rut_ficticio AND CuentaRectP.Mes_trib = RutF_MesTP.Mes_trib
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Total_Decl = ISNULL(Original,0) + ISNULL(Rectificatoria,0)
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Caso_mensual = N'CASO1' WHERE (Original = 1) AND (Rectificatoria IS NULL) AND (Caso_mensual IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Caso_mensual = N'CASO2' WHERE (Original IS NULL) AND (Rectificatoria = 1) AND (Caso_mensual IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Caso_mensual = N'CASO3' WHERE (Original = 1) AND (Rectificatoria = 1) AND (Caso_mensual IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Caso_mensual = N'CASO4' WHERE (Original > 1) AND (Rectificatoria IS NULL) AND (Caso_mensual IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Caso_mensual = N'CASO5' WHERE (Original > 1) AND (Rectificatoria = 1) AND (Caso_mensual IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Caso_mensual = N'CASO6' WHERE (Original > 1) AND (Rectificatoria > 1) AND (Caso_mensual IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Caso_mensual = N'CASO7' WHERE (Original = 1) AND (Rectificatoria > 1) AND (Caso_mensual IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE RutF_MesTP SET Caso_mensual = N'CASO8' WHERE (Original IS NULL) AND (Rectificatoria > 1) AND (Caso_mensual IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET Caso_mensual = RutF_MesTP.Caso_mensual
FROM PanelMensualP INNER JOIN RutF_MesTP ON PanelMensualP.Rut_ficticio = RutF_MesTP.Rut_ficticio AND PanelMensualP.Mes_trib = RutF_MesTP.Mes_trib
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET Seleccion = N'SI', Criterio = N'Declaracion unica' WHERE (Caso_mensual = N'CASO1')
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET Seleccion = N'SI', Criterio = N'Declaracion unica' WHERE (Caso_mensual = N'CASO2')
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET Seleccion = N'SI', Criterio = N'Rectificatoria reemplaza original' WHERE (Origen = N'REC') AND (Caso_mensual = N'CASO3')
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET Seleccion = N'NO', Criterio = N'No seleccionado' WHERE (Origen = N'ORI') AND (Caso_mensual = N'CASO3')
")
sqlQuery(channel = myconn,query = "
SELECT Origen, Rut_ficticio, Mes_trib, Año_trib, Procedencia, FechaPresentacion, Mes_dato, Orden, Folio, FechaProceso, cod20, cod108, cod111, cod112, cod142, cod152,
cod501, cod502, cod510, cod513, cod529, cod587, cod709, cod720, cod732, Seleccion, Criterio, Caso_mensual, Venta_mensual, Suma_codigos
INTO DepuracionP FROM PanelMensualP
WHERE (Seleccion IS NULL) AND (Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
SELECT Rut_ficticio, Mes_trib, MAX(FechaPresentacion) AS Expr1
INTO FMax FROM DepuracionP
GROUP BY Rut_ficticio, Mes_trib
")
sqlQuery(channel = myconn,query = "
SELECT DepuracionP.Rut_ficticio, DepuracionP.Mes_trib, DepuracionP.FechaPresentacion
INTO FMax_Unos
FROM DepuracionP INNER JOIN FMax ON DepuracionP.Rut_ficticio = FMax.Rut_ficticio AND DepuracionP.Mes_trib = FMax.Mes_trib AND DepuracionP.FechaPresentacion = FMax.Expr1
GROUP BY DepuracionP.Rut_ficticio, DepuracionP.Mes_trib, DepuracionP.FechaPresentacion
HAVING (COUNT(DepuracionP.Rut_ficticio) = 1)
")
sqlQuery(channel = myconn,query = "
UPDATE DepuracionP SET Seleccion = N'SI', Criterio = N'MáxFechaPresentación'
FROM DepuracionP INNER JOIN FMax_Unos ON DepuracionP.Rut_ficticio = FMax_Unos.Rut_ficticio AND DepuracionP.Mes_trib = FMax_Unos.Mes_trib AND
DepuracionP.FechaPresentacion = FMax_Unos.FechaPresentacion
")
sqlQuery(channel = myconn,query = "
UPDATE DepuracionP SET Seleccion = N'NO', Criterio = N'No seleccionado'
FROM DepuracionP INNER JOIN FMax_Unos ON DepuracionP.Rut_ficticio = FMax_Unos.Rut_ficticio AND DepuracionP.Mes_trib = FMax_Unos.Mes_trib
WHERE (DepuracionP.Seleccion IS NULL) AND (DepuracionP.Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
DROP TABLE FMax, FMax_Unos
")
sqlQuery(channel = myconn,query = "
SELECT DepuracionP.*, Seleccion AS Expr1, Criterio AS Expr2
INTO Pendientes
FROM DepuracionP
WHERE (Seleccion IS NULL) AND (Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
SELECT Rut_ficticio, Mes_trib, MAX(FechaPresentacion) AS Expr1
INTO FMax
FROM Pendientes
GROUP BY Rut_ficticio, Mes_trib
")
sqlQuery(channel = myconn,query = "
SELECT Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion, MAX(Pendientes.Suma_codigos) AS Expr1
INTO CodMax
FROM Pendientes INNER JOIN FMax ON Pendientes.Rut_ficticio = FMax.Rut_ficticio AND Pendientes.Mes_trib = FMax.Mes_trib AND Pendientes.FechaPresentacion = FMax.Expr1
GROUP BY Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion
")
sqlQuery(channel = myconn,query = "
SELECT Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion, Pendientes.Suma_codigos, COUNT(Pendientes.Rut_ficticio) AS Expr1
INTO FMaxUnos
FROM Pendientes INNER JOIN CodMax ON Pendientes.Rut_ficticio = CodMax.Rut_ficticio AND Pendientes.Mes_trib = CodMax.Mes_trib AND
Pendientes.FechaPresentacion = CodMax.FechaPresentacion AND Pendientes.Suma_codigos = CodMax.Expr1
GROUP BY Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion, Pendientes.Suma_codigos
HAVING (COUNT(Pendientes.Rut_ficticio) = 1)
")
sqlQuery(channel = myconn,query = "
UPDATE DepuracionP SET Seleccion = N'SI', Criterio = N'MáxFechaPresentaciónPrepetida_DeclaraDiferentes_MaxCod'
FROM DepuracionP INNER JOIN FMaxUnos ON DepuracionP.Rut_ficticio = FMaxUnos.Rut_ficticio AND DepuracionP.Mes_trib = FMaxUnos.Mes_trib AND
DepuracionP.FechaPresentacion = FMaxUnos.FechaPresentacion AND DepuracionP.Suma_codigos = FMaxUnos.Suma_codigos
WHERE (DepuracionP.Origen = N'ORI') AND (DepuracionP.Seleccion IS NULL) AND (DepuracionP.Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE DepuracionP SET Seleccion = N'SI', Criterio = N'MáxFechaPresentaciónRrepetida_DeclaraDiferentes_MaxCod'
FROM DepuracionP INNER JOIN FMaxUnos ON DepuracionP.Rut_ficticio = FMaxUnos.Rut_ficticio AND DepuracionP.Mes_trib = FMaxUnos.Mes_trib AND
DepuracionP.FechaPresentacion = FMaxUnos.FechaPresentacion AND DepuracionP.Suma_codigos = FMaxUnos.Suma_codigos
WHERE (DepuracionP.Origen = N'REC') AND (DepuracionP.Seleccion IS NULL) AND (DepuracionP.Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE DepuracionP SET Criterio = N'No seleccionado', Seleccion = N'NO'
FROM DepuracionP INNER JOIN FMaxUnos ON DepuracionP.Rut_ficticio = FMaxUnos.Rut_ficticio AND DepuracionP.Mes_trib = FMaxUnos.Mes_trib
WHERE (DepuracionP.Criterio IS NULL) AND (DepuracionP.Seleccion IS NULL)
")
sqlQuery(channel = myconn,query = "
DROP TABLE FMax, FMaxUnos, CodMax, Pendientes
")
sqlQuery(channel = myconn,query = "
SELECT DepuracionP.*, Seleccion AS Expr1, Criterio AS Expr2
INTO Pendientes
FROM DepuracionP
WHERE (Seleccion IS NULL) AND (Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
SELECT Rut_ficticio, Mes_trib, MAX(FechaPresentacion) AS Expr1
INTO FMax
FROM Pendientes
GROUP BY Rut_ficticio, Mes_trib
")
sqlQuery(channel = myconn,query = "
SELECT Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion, MAX(Pendientes.Suma_codigos) AS Expr1
INTO CodMax
FROM Pendientes INNER JOIN FMax ON Pendientes.Rut_ficticio = FMax.Rut_ficticio AND Pendientes.Mes_trib = FMax.Mes_trib AND Pendientes.FechaPresentacion = FMax.Expr1
GROUP BY Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion
")
sqlQuery(channel = myconn,query = "
SELECT Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion, Pendientes.Suma_codigos, MAX(Pendientes.Orden) AS MaxOrden
INTO OrdenMax
FROM Pendientes INNER JOIN CodMax AS CodMax_1 ON Pendientes.Rut_ficticio = CodMax_1.Rut_ficticio AND Pendientes.Mes_trib = CodMax_1.Mes_trib AND
Pendientes.FechaPresentacion = CodMax_1.FechaPresentacion AND Pendientes.Suma_codigos = CodMax_1.Expr1
GROUP BY Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion, Pendientes.Suma_codigos
")
sqlQuery(channel = myconn,query = "
SELECT Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion, Pendientes.Suma_codigos, OrdenMax.MaxOrden
INTO Unos
FROM Pendientes INNER JOIN OrdenMax ON Pendientes.Rut_ficticio = OrdenMax.Rut_ficticio AND Pendientes.Mes_trib = OrdenMax.Mes_trib AND
Pendientes.FechaPresentacion = OrdenMax.FechaPresentacion AND Pendientes.Suma_codigos = OrdenMax.Suma_codigos AND
Pendientes.Orden = OrdenMax.MaxOrden
GROUP BY Pendientes.Rut_ficticio, Pendientes.Mes_trib, Pendientes.FechaPresentacion, Pendientes.Suma_codigos, OrdenMax.MaxOrden
HAVING (COUNT(Pendientes.Rut_ficticio) = 1)
")
sqlQuery(channel = myconn,query = "
UPDATE DepuracionP SET Seleccion = N'SI', Criterio = N'MáxFechaPresentaciónPrepetida_DeclaraIgual_MaxOrden'
FROM DepuracionP INNER JOIN Unos ON DepuracionP.Rut_ficticio = Unos.Rut_ficticio AND DepuracionP.Mes_trib = Unos.Mes_trib AND DepuracionP.FechaPresentacion = Unos.FechaPresentacion AND
DepuracionP.Suma_codigos = Unos.Suma_codigos AND DepuracionP.Orden = Unos.MaxOrden
WHERE (DepuracionP.Origen = N'ORI') AND (DepuracionP.Seleccion IS NULL) AND (DepuracionP.Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE DepuracionP SET Seleccion = N'SI', Criterio = N'MáxFechaPresentaciónRrepetida_DeclaraIgual_MaxOrden'
FROM DepuracionP INNER JOIN Unos ON DepuracionP.Rut_ficticio = Unos.Rut_ficticio AND DepuracionP.Mes_trib = Unos.Mes_trib AND DepuracionP.FechaPresentacion = Unos.FechaPresentacion AND
DepuracionP.Suma_codigos = Unos.Suma_codigos AND DepuracionP.Orden = Unos.MaxOrden
WHERE (DepuracionP.Origen = N'REC') AND (DepuracionP.Seleccion IS NULL) AND (DepuracionP.Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE DepuracionP SET Criterio = N'No seleccionado', Seleccion = N'NO'
FROM DepuracionP INNER JOIN Unos ON DepuracionP.Rut_ficticio = Unos.Rut_ficticio AND DepuracionP.Mes_trib = Unos.Mes_trib
WHERE (DepuracionP.Criterio IS NULL) AND (DepuracionP.Seleccion IS NULL)
")
sqlQuery(channel = myconn,query = "
DROP TABLE FMax, CodMax, OrdenMax, Unos, Pendientes
")
sqlQuery(channel = myconn,query = "
UPDATE PanelMensualP SET Seleccion = DepuracionP.Seleccion, Criterio = DepuracionP.Criterio
FROM DepuracionP INNER JOIN PanelMensualP ON DepuracionP.Rut_ficticio = PanelMensualP.Rut_ficticio AND DepuracionP.Mes_trib = PanelMensualP.Mes_trib AND
DepuracionP.Mes_dato = PanelMensualP.Mes_dato AND DepuracionP.Orden = PanelMensualP.Orden
WHERE (PanelMensualP.Seleccion IS NULL) AND (PanelMensualP.Criterio IS NULL)
")
sqlQuery(channel = myconn,query = "
SELECT Seleccion, Rut_ficticio INTO VentasMesP
FROM PanelMensualP GROUP BY Seleccion, Rut_ficticio HAVING (Seleccion = N'SI')
")
sqlQuery(channel = myconn,query = "
ALTER TABLE VentasMesP ADD ENE float;
ALTER TABLE VentasMesP ADD FEB float;
ALTER TABLE VentasMesP ADD MAR float;
ALTER TABLE VentasMesP ADD ABR float;
ALTER TABLE VentasMesP ADD MAY float;
ALTER TABLE VentasMesP ADD JUN float;
ALTER TABLE VentasMesP ADD JUL float;
ALTER TABLE VentasMesP ADD AGO float;
ALTER TABLE VentasMesP ADD SEP float;
ALTER TABLE VentasMesP ADD OCT float;
ALTER TABLE VentasMesP ADD NOV float;
ALTER TABLE VentasMesP ADD DIC float;
ALTER TABLE VentasMesP ADD Venta_anual float;
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET ENE = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 1) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.ENE IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET FEB = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 2) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.FEB IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET MAR = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 3) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.MAR IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET ABR = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 4) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.ABR IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET MAY = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 5) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.MAY IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET JUN = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 6) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.JUN IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET JUL = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 7) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.JUL IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET AGO = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 8) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.AGO IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET SEP = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 9) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.SEP IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET OCT = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 10) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.nov IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET NOV = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 11) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.NOV IS NULL)
")
sqlQuery(channel = myconn,query = "
UPDATE VentasMesP SET DIC = PanelMensualP.Venta_mensual
FROM VentasMesP INNER JOIN PanelMensualP ON VentasMesP.Rut_ficticio = PanelMensualP.Rut_ficticio
WHERE (PanelMensualP.Mes_trib = 12) AND (PanelMensualP.Seleccion = N'SI') AND (VentasMesP.DIC IS NULL)
")
sqlQuery(channel = myconn,query = "
INSERT INTO VentasMesP (Rut_ficticio)
SELECT TotalULP.Rut_ficticio
FROM TotalULP LEFT OUTER JOIN VentasMesP AS VentasMesP_1 ON TotalULP.Rut_ficticio = VentasMesP_1.Rut_ficticio
WHERE (VentasMesP_1.Rut_ficticio IS NULL) AND (TotalULP.Observacion <> 'EJERCICIO DE PRUEBA' OR TotalULP.Observacion IS NULL)
")
sqlQuery(channel = myconn,query = "
--DROP TABLE oriP, recP, CodOri_2019P, CodRec_2019P, CuentaOrigP, CuentaRectP, DepuracionP, RutF_MesTP
--DROP TABLE TotalULP, PanelMensualP, VentasMesP
")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment