UDF SPLIT:

UDF SPLIT:


declare @a varchar(max)='1,2,3',@b varchar(max)='3,4,5'
select A.Value,B.Value from udf_split(@a,',') A 
left join udf_split(@b,',') B on A.ID=B.ID