Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
5| Name | Data Type | Length | Description |
|---|---|---|---|
| @p_cuit | varchar | 50 | |
| @p_procedencia | varchar | 50 | |
| @p_fobusd | varchar | 50 | |
| @p_posicion | varchar | 50 | |
| @p_fecha | varchar | 10 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.ADUANA_impo_insertar
@p_cuit varchar(50),
@p_procedencia varchar(50),
@p_fobusd varchar(50),
@p_posicion varchar(50),
@p_fecha varchar(10)
AS
BEGIN
BEGIN TRY
SET NOCOUNT ON;
--- truncate table comex_importaciones2
/*
select count(*) from comex_importaciones2 --702112
select count(*) from comercio_exterior2
select count(*) from comex_exportaciones2
select count(*) from comex_importaciones2
select count(*) from comex_exportaciones2
select count(*) from comercio_exterior2
select * from comex_importaciones where created > getdate()-30 and fecha < '2024-08-01' order by impo_id desc
select * from comex_exportaciones where created > getdate()-30 and fecha > '2024-07-01' order by impo_id desc
select * from comercioexterior where created > getdate()-30 order by impo_id desc
select distinct fecha from comex_importaciones2 order by fecha
*/
-- select count(*) from comex_importaciones2 where fecha > '2020-07-31'
-- select top 10 * from comex_importaciones2 where cuit='30678519681' and posicion=8708
--select distinct cuit,procedencia,fobusd,posicion,fecha from comex_importaciones2
BEGIN
INSERT INTO comex_importaciones (cuit,procedencia,fobusd,posicion,fecha)
VALUES (@p_cuit,@p_procedencia,@p_fobusd,@p_posicion,@p_fecha)
END
END TRY
BEGIN CATCH
--SELECT ERROR_MESSAGE()
END CATCH
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.ADUANA_impo_insertar
@p_cuit varchar(50),
@p_procedencia varchar(50),
@p_fobusd varchar(50),
@p_posicion varchar(50),
@p_fecha varchar(10)
AS
BEGIN
BEGIN TRY
SET NOCOUNT ON;
--- truncate table comex_importaciones2
/*
select count(*) from comex_importaciones2 --702112
select count(*) from comercio_exterior2
select count(*) from comex_exportaciones2
select count(*) from comex_importaciones2
select count(*) from comex_exportaciones2
select count(*) from comercio_exterior2
select * from comex_importaciones where created > getdate()-30 and fecha < '2024-08-01' order by impo_id desc
select * from comex_exportaciones where created > getdate()-30 and fecha > '2024-07-01' order by impo_id desc
select * from comercioexterior where created > getdate()-30 order by impo_id desc
select distinct fecha from comex_importaciones2 order by fecha
*/
-- select count(*) from comex_importaciones2 where fecha > '2020-07-31'
-- select top 10 * from comex_importaciones2 where cuit='30678519681' and posicion=8708
--select distinct cuit,procedencia,fobusd,posicion,fecha from comex_importaciones2
BEGIN
INSERT INTO comex_importaciones (cuit,procedencia,fobusd,posicion,fecha)
VALUES (@p_cuit,@p_procedencia,@p_fobusd,@p_posicion,@p_fecha)
END
END TRY
BEGIN CATCH
--SELECT ERROR_MESSAGE()
END CATCH
END
GO
Depends On
1Used By
No items found