Comma delimited column value into table structure

Hi,

Try like this

SELECT T.value 'SongsName', M.PlstID
FROM yourTable M
INNER JOIN (SLECT value FROM dbo.splitFunction (M.SongsName,',')) T ON 1=1
-- User Define Function (dbo.splitFunction)

Regards,
GVPrabu

Try this:

DECLARE @tmp TABLE (SongsName VARCHAR(300), PlstID INT)

INSERT INTO @tmp (SongsName, PlstID)
VALUES('a,b,c,d,e', 166)
INSERT INTO @tmp (SongsName, PlstID)
VALUES('a,d,e,f,g', 165)

;WITH CTESongs AS
(
	SELECT PlstID, LEFT(SongsName, CHARINDEX(',',SongsName)-1) AS Song, RIGHT(SongsName, LEN(SongsName) - CHARINDEX(',',SongsName)) AS Remainder
	FROM @tmp
	WHERE CHARINDEX(',',SongsName)>0
	UNION ALL
	SELECT PlstID, LEFT(Remainder, CHARINDEX(',',Remainder)-1) AS Song, RIGHT(Remainder, LEN(Remainder) - CHARINDEX(',',Remainder)) AS Remainder
	FROM CTESongs
	WHERE CHARINDEX(',',Remainder)>0
	UNION ALL
	SELECT PlstID, Remainder AS Song, NULL AS Remainder
	FROM CTESongs
	WHERE CHARINDEX(',',Remainder)=0
)
SELECT *
FROM CTESongs
--ORDER BY PlstID, Song

Have a look here: WITH Common table expression[^]

We have the best example to solve the comma separated value of field in sql server

declare @String as varchar(max)
declare @Delimiter as char(1)
declare @str as varchar(max)
declare @s as varchar(max)
declare @charIndex as int
declare @b as int

set @Delimiter = ',';
set @string = a(01:00:00),b(02:00:00),c(03:00:00),d(04:00:00);

create table #temptable(Items varchar(max))

declare @idx int
declare @slice varchar(8000)

select @idx = 1
if len(@String)<1 or @String is null return

while @idx!= 0
begin
set @idx = charindex(@Delimiter,@String)
if @idx!=0
set @slice = left(@String,@idx - 1)
else
set @slice = @String

if(len(@slice)>0)


set @charIndex = CHARINDEX('(',@slice)
set @str = SUBSTRING(@slice,0,@charIndex)

insert into #temptable(Items) values(@str)

set @String = right(@String,len(@String) - @idx)
if len(@String) = 0 break
end

select * from #temptable

drop table #temptable