Split string In sql server Get table format

////////////////////

CREATE FUNCTION [dbo].[SplitString_TableFormat]

(

    @String NVARCHAR(4000),

    @Delimiter NCHAR(1)

)

RETURNS TABLE

AS

RETURN

(

    WITH Split(stpos,endpos)

    AS(

        SELECT 0 AS stpos, CHARINDEX(@Delimiter,@String) AS endpos

        UNION ALL

        SELECT endpos+1, CHARINDEX(@Delimiter,@String,endpos+1)

            FROM Split

            WHERE endpos > 0

    )

    SELECT 'Id' = ROW_NUMBER() OVER (ORDER BY (SELECT 1)),

        'Value' = SUBSTRING(@String,stpos,COALESCE(NULLIF(endpos,0),LEN(@String)+1)-stpos)

    FROM Split

)

//////////////////////// Call function

SELECT a.Name,a.Name1, b.value

FROM TableName a

JOIN STRING_SPLIT('316,317,318,319,320,321,322,323,324,325,326,327,328,329,330', ',') AS b ON a.value = b.value