NuRoN Consulting, INC.

Blog > SQL Tools > Databases > Util > Functions > dbo.ProcedureInputDelimitedTable

Dependencies for SQL inline table-valued function: Util.dbo.ProcedureInputDelimitedTable

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.dbo.ProcedureInputDelimitedTable	SQL inline table-valued function	Util.dbo.ParseDelimited	SQL inline table-valued function	1	[Util].[dbo].[ParseDelimited]
Util.dbo.ParseDelimited	SQL inline table-valued function	Util.dbo.ParseDelimited_CLR	Assembly (CLR) table-valued function	2	[Util].[dbo].[ParseDelimited], [Util].[dbo].[ParseDelimited_CLR]
Util.dbo.ParseDelimited_CLR	Assembly (CLR) table-valued function	Util.UtilClr	ASSEMBLY	3	[Util].[dbo].[ParseDelimited], [Util].[dbo].[ParseDelimited_CLR], [Util].[UtilClr]

SQL inline table-valued function: Util.dbo.ProcedureInputDelimitedTable

CREATE FUNCTION dbo.ProcedureInputDelimitedTable (@Input VARCHAR(MAX))
RETURNS TABLE
    AS
RETURN
    SELECT
DISTINCT    LTRIM(RTRIM(Field)) AS Field
    FROM    dbo.ParseDelimited(REPLACE(REPLACE(REPLACE(@Input, '    ', ','), ' ', ','), '
', ','), ',')
    WHERE   LTRIM(RTRIM(Field)) <> ''

Description for SQL inline table-valued function: Util.dbo.ProcedureInputDelimitedTable

Todo