By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare @var_1 nvarchar(max) = 'Apple.jpg,Carrot.png,Fruits.pdf'
declare @var_2 nvarchar(max) = '9V0I1fab\CvaA5h,IV0asdkas//bVasA,Uasdl00/9asA'
select s1.value as name, s2.value as b64
from (select s.value,
row_number() over (order by charindex(',' + s.value + ',', ',' + @var_1 + ',')) as seqnum
from string_split(@var_1, ',') s
) s1 join
(select s.value,
row_number() over (order by charindex(',' + s.value + ',', ',' + @var_2 + ',')) as seqnum
from string_split(@var_2, ',') s
) s2
on s1.seqnum = s2.seqnum;
| name | b64 |
|---|---|
| Apple.jpg | 9V0I1fab\CvaA5h |
| Carrot.png | IV0asdkas//bVasA |
| Fruits.pdf | Uasdl00/9asA |