Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*
exec insertar_domicilio_persona_fisica_afip '20177260909','1426','AV OLLEROS 1878 P 6 B','CABA',0,'CABA','O','AV JUAN JOSE OLLEROS','1878','06','B'
exec insertar_domicilio_persona_fisica_afip '20177260909','1426','AV OLLEROS 1878 P 6 B','CABA',0,'CABA','O'
*/
CREATE OR ALTER PROCEDURE dbo.domicilios_normalizar
AS
BEGIN
SET NOCOUNT ON;
/*select TOP 100 * from domicilios_todos where calle is not null and tipo_domicilio='F' and nombre_fuente='AFIP'*/
select TOP 100 * from domicilios_todos where calle is null and tipo_domicilio='F' and nombre_fuente='AFIP'
END
GO
GO
/*
exec insertar_domicilio_persona_fisica_afip '20177260909','1426','AV OLLEROS 1878 P 6 B','CABA',0,'CABA','O','AV JUAN JOSE OLLEROS','1878','06','B'
exec insertar_domicilio_persona_fisica_afip '20177260909','1426','AV OLLEROS 1878 P 6 B','CABA',0,'CABA','O'
*/
CREATE OR ALTER PROCEDURE dbo.domicilios_normalizar
AS
BEGIN
SET NOCOUNT ON;
/*select TOP 100 * from domicilios_todos where calle is not null and tipo_domicilio='F' and nombre_fuente='AFIP'*/
select TOP 100 * from domicilios_todos where calle is null and tipo_domicilio='F' and nombre_fuente='AFIP'
END
GO
Depends On
1Used By
No items found