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
CREATE OR ALTER PROCEDURE dbo.obtener_monitoreos_a_vencer
AS
BEGIN
SET NOCOUNT ON;
select distinct m.cliente, c.cli_codigo, c.nombre_cliente,
m.cuit as cuit_consultado, p.nombre_persona as nombre_consultado,
(CONVERT(VARCHAR(10),fecha_vigencia_mantenimiento, 103)) as vencimiento
From monitoreos m
inner join clientes c on c.cliente = m.cliente
inner join padrones p on p.identificacion = m.cuit and p.habilitado = 1
where fecha_vigencia_mantenimiento between getdate() and DATEADD(day,30,getdate())
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.obtener_monitoreos_a_vencer
AS
BEGIN
SET NOCOUNT ON;
select distinct m.cliente, c.cli_codigo, c.nombre_cliente,
m.cuit as cuit_consultado, p.nombre_persona as nombre_consultado,
(CONVERT(VARCHAR(10),fecha_vigencia_mantenimiento, 103)) as vencimiento
From monitoreos m
inner join clientes c on c.cliente = m.cliente
inner join padrones p on p.identificacion = m.cuit and p.habilitado = 1
where fecha_vigencia_mantenimiento between getdate() and DATEADD(day,30,getdate())
END
GO
Depends On
3Used By
No items found