Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Null on Null Input | False |
| Schema Bound | False |
| Assembly |
Parameters
2| Name | Data Type | Length | Description |
|---|---|---|---|
| (Result) | varchar | 150 | |
| @familia | int | 4 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- 1. CREAR ESA FUNCION
-- Create the function in the specified schema
CREATE OR ALTER FUNCTION dbo.SubsetsFamilia(@familia int)
RETURNS VARCHAR(150)
AS
BEGIN
RETURN (
SELECT STUFF(
(
SELECT ','+LN_familias_tipo_informe.lista_subset
FROM LN_familias_tipo_informe
WHERE (LN_familias_tipo_informe.familia=@familia AND LN_familias_tipo_informe.visible=1)
FOR XML PATH ('')
)
,1,1, '')
);
END
GO
GO
-- 1. CREAR ESA FUNCION
-- Create the function in the specified schema
CREATE OR ALTER FUNCTION dbo.SubsetsFamilia(@familia int)
RETURNS VARCHAR(150)
AS
BEGIN
RETURN (
SELECT STUFF(
(
SELECT ','+LN_familias_tipo_informe.lista_subset
FROM LN_familias_tipo_informe
WHERE (LN_familias_tipo_informe.familia=@familia AND LN_familias_tipo_informe.visible=1)
FOR XML PATH ('')
)
,1,1, '')
);
END
GO