fnMakeIDsTableFromString

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@IDString nvarchar(max) IN
@Delim nvarchar(8) IN

Definition

Copy


        CREATE function [dbo].[fnMakeIDsTableFromString](@IDString nvarchar(max), @Delim nvarchar(8))
        returns @IDTable TABLE(id integer)
        as begin

            declare @intPos INTEGER

            set @intPos = charindex(@Delim,@IDString)
            while @intPos > 0
                begin
                insert into @IDTable select left(@IDString,@intPos-1)
                set @IDString = substring(@IDString,@intPos+1,LEN(@IDString)-@intPos)
                set @intPos = charindex(@Delim,@IDString)
                end

            if (len(@IDString) > 0)
                insert into @IDTable select @IDString
            return
        end