comma separated values to rows in sql server

Question

how to inserted comma separated values to rows in sql server

Govinda Rajulu Yemineni · Answer

Hi Rohan Gupta create function [dbo].[ufn__SplitString] (@str varchar (100)@delim varchar (10)) returns @table table (value varchar (50)) as BEGIN declare @value varchar (50) set @value='' while ( CHARINDEX (@delim@str)!=0) BEGIN select @value= SUBSTRING (@str1 CHARINDEX (@delim@str)-1) select @str= SUBSTRING (@str CHARINDEX (@delim@str)+1 LEN (@str)) insert into @table values (@value) END insert into @table values (@str) return END select * from dbo.[ufn__SplitString]( 'abc123xyzrajulu'  '' )

Sujeet Suman · Answer

Rohan please once go through following link: http://stackoverflow.com/questions/14811316/separate-comma-separated-values-and-store-in-table-in-sql-server