Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
3| Name | Data Type | Length | Description |
|---|---|---|---|
| @periodo | date | 3 | |
| @prov_1 | varchar | 20 | |
| @prov_2 | varchar | 20 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.copyle_1_select_provincias
@periodo date = '2018-03-01',
@prov_1 varchar(20) = 'SANTA FE',
@prov_2 varchar(20) = 'CORDOBA'/*,
@prov_3 varchar(20) = 'SAN JUAN'*/
AS
BEGIN
SET NOCOUNT ON;
insert into copyle_cuits (identificacion,provincia,localidad,score,periodo,situacion_1,codigo_postal,domicilio_legal)
select cuit as identificacion,prv_nombre as provincia,loc_nombre as localidad,'' as score,@periodo as periodo,0 as situacion_1,codpos,domicilio from domicilios_todos where tipo_domicilio = 'F' and prv_nombre = @prov_1 and cuit like '2%' and LEN(cuit) = 11 and visible = 1
union all
select cuit as identificacion,prv_nombre as provincia,loc_nombre as localidad,'' as score,@periodo as periodo,0 as situacion_1,codpos,domicilio from domicilios_todos where tipo_domicilio = 'F' and prv_nombre = @prov_2 and cuit like '2%' and LEN(cuit) = 11 and visible = 1
/* union all
select cuit as identificacion,prv_nombre as provincia,loc_nombre as localidad,'' as score,@periodo as periodo,0 as situacion_1,codpos,domicilio from domicilios_todos where tipo_domicilio = 'F' and prv_nombre = @prov_3 and cuit like '2%' and LEN(cuit) = 11 and visible = 1*/
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.copyle_1_select_provincias
@periodo date = '2018-03-01',
@prov_1 varchar(20) = 'SANTA FE',
@prov_2 varchar(20) = 'CORDOBA'/*,
@prov_3 varchar(20) = 'SAN JUAN'*/
AS
BEGIN
SET NOCOUNT ON;
insert into copyle_cuits (identificacion,provincia,localidad,score,periodo,situacion_1,codigo_postal,domicilio_legal)
select cuit as identificacion,prv_nombre as provincia,loc_nombre as localidad,'' as score,@periodo as periodo,0 as situacion_1,codpos,domicilio from domicilios_todos where tipo_domicilio = 'F' and prv_nombre = @prov_1 and cuit like '2%' and LEN(cuit) = 11 and visible = 1
union all
select cuit as identificacion,prv_nombre as provincia,loc_nombre as localidad,'' as score,@periodo as periodo,0 as situacion_1,codpos,domicilio from domicilios_todos where tipo_domicilio = 'F' and prv_nombre = @prov_2 and cuit like '2%' and LEN(cuit) = 11 and visible = 1
/* union all
select cuit as identificacion,prv_nombre as provincia,loc_nombre as localidad,'' as score,@periodo as periodo,0 as situacion_1,codpos,domicilio from domicilios_todos where tipo_domicilio = 'F' and prv_nombre = @prov_3 and cuit like '2%' and LEN(cuit) = 11 and visible = 1*/
END
GO
Used By
No items found