Hi,
Check the following link for Split Function... then u will use one variable for Get the ColumnA value and place in final Select Statement.
Like
DECLARE @ColA VARCHAR(1000), @ColB VARCHAR(1000)
SELECT @ColA = columnA, @ColB = columnB FROM Table_Name
SELECT @ColA,ColumnValues FROM fnSplit(@ColB ,',')
If any Clarifications, Check the following link
Split function error - The statement terminated. The maximum recursion 100 has been exhausted before statement completion[
^]
Regards,
GVPRabu