Insert Comma seperated values into table

Code Starts here---->>>>>

CREATE PROCEDURE [dbo].[YourProcedure](@string varchar(50))
AS
DECLARE @pos integer = 1,
@previous_pos integer = 0,
@value varchar(50)
BEGIN
WHILE @pos > 0
BEGIN
SET @pos = CHARINDEX(',',@string,@previous_pos+1)
IF @pos > 0
BEGIN
SET @value = SUBSTRING(@string,@previous_pos+1,@pos-@previous_pos-1)
INSERT INTO YourTable VALUES (@value)
SET @previous_pos = @pos
END
END
IF @previous_pos < LEN(@string)
BEGIN
SET @value = SUBSTRING(@string,@previous_pos+1,LEN(@string))
INSERT INTO YourTable VALUES (@value)
END
END