Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @cliente | int | 4 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
--delete from procesos_masivos
--select * from procesos_masivos
/*
select * from procesos_cuit where fecha = '2021-10-14' and cuit = '27208925658'
select * from consultar_afip where fecha = '2021-10-14' and cuit = '27208925658'
*/
CREATE OR ALTER PROCEDURE dbo.screening_fecha_ultimo_proceso
@cliente int
AS
BEGIN
BEGIN TRY
SET NOCOUNT ON;
select max(fecha) as fecha from
procesos_cuit where cliente = @cliente
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() as error
END CATCH
END
GO
GO
--delete from procesos_masivos
--select * from procesos_masivos
/*
select * from procesos_cuit where fecha = '2021-10-14' and cuit = '27208925658'
select * from consultar_afip where fecha = '2021-10-14' and cuit = '27208925658'
*/
CREATE OR ALTER PROCEDURE dbo.screening_fecha_ultimo_proceso
@cliente int
AS
BEGIN
BEGIN TRY
SET NOCOUNT ON;
select max(fecha) as fecha from
procesos_cuit where cliente = @cliente
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() as error
END CATCH
END
GO
Depends On
1Used By
No items found