Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @p_cuit | varchar | 20 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- =============================================
-- Author: <Samuel Gonzalez>
-- Create date: <Tue 11 Jul 2017>
-- Description: <Obtener fecha de creación del último registro perteneciente a CUIT>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.obtener_ultimo_vencimiento_obligacion
-- Add the parameters for the stored procedure here
@p_cuit varchar(20)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT TOP 1 created FROM vencimientos_obligaciones WHERE (cuit = @p_cuit) ORDER BY created DESC
END
GO
GO
-- =============================================
-- Author: <Samuel Gonzalez>
-- Create date: <Tue 11 Jul 2017>
-- Description: <Obtener fecha de creación del último registro perteneciente a CUIT>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.obtener_ultimo_vencimiento_obligacion
-- Add the parameters for the stored procedure here
@p_cuit varchar(20)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT TOP 1 created FROM vencimientos_obligaciones WHERE (cuit = @p_cuit) ORDER BY created DESC
END
GO
Depends On
1Used By
No items found