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.AGB_BULK_FIDECHECK
AS
BEGIN
SET NOCOUNT ON;
select LN_contraparte_familias.contraparte,LN_contrapartes.cliente from
LN_contraparte_familias inner join LN_contrapartes on LN_contraparte_familias.contraparte = LN_contrapartes.contraparte
where familia in (73,75,116)
and LN_contraparte_familias.contraparte in (
select distinct contraparte from LN_contrapartes where cliente = 2046807993 and activo = 1 and created > '2020-01-01 00:00:00')
union
select LN_contraparte_familias.contraparte,LN_contrapartes.cliente from
LN_contraparte_familias inner join LN_contrapartes on LN_contraparte_familias.contraparte = LN_contrapartes.contraparte
where familia in (189)
and LN_contraparte_familias.contraparte in (
select distinct contraparte from LN_contrapartes where cliente = 5546348 and activo = 1 and created > '2020-01-01 00:00:00')
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.AGB_BULK_FIDECHECK
AS
BEGIN
SET NOCOUNT ON;
select LN_contraparte_familias.contraparte,LN_contrapartes.cliente from
LN_contraparte_familias inner join LN_contrapartes on LN_contraparte_familias.contraparte = LN_contrapartes.contraparte
where familia in (73,75,116)
and LN_contraparte_familias.contraparte in (
select distinct contraparte from LN_contrapartes where cliente = 2046807993 and activo = 1 and created > '2020-01-01 00:00:00')
union
select LN_contraparte_familias.contraparte,LN_contrapartes.cliente from
LN_contraparte_familias inner join LN_contrapartes on LN_contraparte_familias.contraparte = LN_contrapartes.contraparte
where familia in (189)
and LN_contraparte_familias.contraparte in (
select distinct contraparte from LN_contrapartes where cliente = 5546348 and activo = 1 and created > '2020-01-01 00:00:00')
END
GO
Depends On
2Used By
No items found