Sql

declare @commasepvalue varchar(50)='1,2,3,4,5' select q2.value from (SELECT cast(''+replace(@commasepvalue,',','')+'' as xml) as thexml)q1 CROSS APPLY (SELECT x.value('.','varchar(100)') as value FROM thexml.nodes('x') as f(x))q2

 

 

 

answer i found  

SELECT A.Id AS [ID],A.Name AS [Name], A.Location AS [Location] FROM TableName T

CROSS APPLY (SELECT * FROM [CSVToTableWithID](T.ID, T.Name,T.Location)) A