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 | 13 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.obtener_personas_relacionadas
@p_cuit varchar(13)
AS
BEGIN
SET NOCOUNT ON;
declare @cantidad int
select @cantidad = count(*) from socios where socios.c01_cuit = @p_cuit and socios.visible = 1 and c04_ultimo = 'S'
select TOP 6 @cantidad as cantidad,car_nombre,nombre_persona from socios
inner join cargos
on cargos.car_codigo = socios.car_codigo
inner join padrones
on padrones.identificacion = socios.c01_cuit_soc
where socios.c01_cuit = @p_cuit and socios.visible = 1 and c04_ultimo = 'S'
order by car_orden asc
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.obtener_personas_relacionadas
@p_cuit varchar(13)
AS
BEGIN
SET NOCOUNT ON;
declare @cantidad int
select @cantidad = count(*) from socios where socios.c01_cuit = @p_cuit and socios.visible = 1 and c04_ultimo = 'S'
select TOP 6 @cantidad as cantidad,car_nombre,nombre_persona from socios
inner join cargos
on cargos.car_codigo = socios.car_codigo
inner join padrones
on padrones.identificacion = socios.c01_cuit_soc
where socios.c01_cuit = @p_cuit and socios.visible = 1 and c04_ultimo = 'S'
order by car_orden asc
END
GO
Depends On
3Used By
No items found