Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
3| Name | Data Type | Length | Description |
|---|---|---|---|
| @cuit | varchar | 20 | |
| @client_id | int | 4 | |
| @user_id | int | 4 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.score_obtener_killers_personalizados
@cuit varchar(20),
@client_id int,
@user_id int = null
AS
BEGIN
SET NOCOUNT ON;
select * from score_personalizado where killer = 1 and client_id = @client_id order by id_grupo
END
--insert into score_personalizado (client_id,user_id,id_formula,id_grupo,nombre_grupo,afecta_directo,item,codigo,cant_desde,cant_hasta,dias_desde,dias_hasta,valor,created,killer) values (2254875,33039322,1,3,'Central_de_deudores',1,'Situacion_5',5,NULL,NULL,31,60,0,getdate(),1)
GO
GO
CREATE OR ALTER PROCEDURE dbo.score_obtener_killers_personalizados
@cuit varchar(20),
@client_id int,
@user_id int = null
AS
BEGIN
SET NOCOUNT ON;
select * from score_personalizado where killer = 1 and client_id = @client_id order by id_grupo
END
--insert into score_personalizado (client_id,user_id,id_formula,id_grupo,nombre_grupo,afecta_directo,item,codigo,cant_desde,cant_hasta,dias_desde,dias_hasta,valor,created,killer) values (2254875,33039322,1,3,'Central_de_deudores',1,'Situacion_5',5,NULL,NULL,31,60,0,getdate(),1)
GO
Depends On
1Used By
No items found