Delete string from first table and add in second table every time execute in SQL Server

Hi RPA,

Refer the below query.

SQL

--CREATE TABLE tbl(id int, name varchar(100))
--INSERT INTO tbl VALUES(1, 'orange,apple,cherry,melon')
--CREATE TABLE tabl(id int, name varchar(100))
--TRUNCATE TABLE tbl
--TRUNCATE TABLE tabl

DECLARE @Id INT
SET @Id = 1
DECLARE @result INT
SET @result = (SELECT SUM(LEN(name) - LEN(REPLACE(name,',','')) + 1) resust FROM tbl)
IF @result > 1
	BEGIN
		DECLARE @name VARCHAR(50)
		SET @name = (SELECT name FROM tbl)
		PRINT @name
		DECLARE @a VARCHAR(50)
		SET @a = (SELECT SUBSTRING(@name,0,(CHARINDEX(',',@name,0))))
		PRINT @a
		DECLARE @b VARCHAR(50)
		SET @b = (SELECT SUBSTRING(@name,(CHARINDEX(',',@name,0) + 1),100))
		PRINT @b
		IF EXISTS (SELECT id FROM tabl WHERE id = @Id)
			BEGIN
				DECLARE @GetPreviousName VARCHAR(50)
				SET @GetPreviousName = (SELECT name FROM tabl WHERE id = @Id)
				PRINT @GetPreviousName
				UPDATE tabl SET name = @GetPreviousName + ',' + @a
				UPDATE tbl SET name = @b WHERE id = @Id
			END
		ELSE
			BEGIN
				INSERT INTO tabl(id, name) VALUES(@Id,@a)
				UPDATE tbl SET name = @b WHERE id = @Id
			END
	END
ELSE
	BEGIN
		DECLARE @name1 VARCHAR(50)
		SET @name1 = (SELECT name FROM tbl)
		IF LEN(@name1) > 0
		BEGIN
			DECLARE @GetPreviousName1 VARCHAR(50)
			SET @GetPreviousName1 = (SELECT name FROM tabl WHERE id = @Id)
			PRINT @GetPreviousName1
			UPDATE tabl SET name = @GetPreviousName1 + ',' + @name1
			UPDATE tbl SET name = NULL WHERE id = @Id
		END
	END

SELECT * FROM tbl
SELECT * FROM tabl

Screenshot