Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
2| Name | Data Type | Length | Description |
|---|---|---|---|
| @idreg | int | 4 | |
| @ierror | bit | 1 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*
select * from domicilios_todos where cuit = '20225157937' and tipo_domicilio = 'E'
exec [actualizar_datos_con_padron] '20288662682'
select * from domicilios_todos where cuit = '20225157937' and tipo_domicilio = 'E'
select * from padron_electoral where documento = '22515793'
*/
CREATE OR ALTER PROCEDURE dbo.AFIP_UPD_BATCH_NOCTURNO
@idreg int,
/*
@cuit varchar(20),
*/
@ierror bit
AS
BEGIN
SET NOCOUNT ON;
/*
update consultar_afip set procesado=1,fecha_proceso=getdate(),ierror =@ierror
where cuit =@cuit and proceso in ('FNAC2021','SUBCAMX','ESTRELLA','SUBAMX','INSCRIPCIONES','UK','ESTRELLA','SOBLIGADOS','PAEIMPERIUM','MUERTITOS0521','PROCESOS_MASIVOS')
*/
update consultar_afip set procesado=1,fecha_proceso=getdate(),ierror =@ierror
where idreg = @idreg
END
GO
GO
/*
select * from domicilios_todos where cuit = '20225157937' and tipo_domicilio = 'E'
exec [actualizar_datos_con_padron] '20288662682'
select * from domicilios_todos where cuit = '20225157937' and tipo_domicilio = 'E'
select * from padron_electoral where documento = '22515793'
*/
CREATE OR ALTER PROCEDURE dbo.AFIP_UPD_BATCH_NOCTURNO
@idreg int,
/*
@cuit varchar(20),
*/
@ierror bit
AS
BEGIN
SET NOCOUNT ON;
/*
update consultar_afip set procesado=1,fecha_proceso=getdate(),ierror =@ierror
where cuit =@cuit and proceso in ('FNAC2021','SUBCAMX','ESTRELLA','SUBAMX','INSCRIPCIONES','UK','ESTRELLA','SOBLIGADOS','PAEIMPERIUM','MUERTITOS0521','PROCESOS_MASIVOS')
*/
update consultar_afip set procesado=1,fecha_proceso=getdate(),ierror =@ierror
where idreg = @idreg
END
GO
Depends On
1Used By
No items found