Can i pass more than two column names to split function?

Maybe this could work for you.

First extend your funciton to keep an identifier in your table(@c).

create function split (@list varchar(max), @delimiter char(1))
returns @shards table (id integer, value varchar(8000))
with schemabinding
as
begin
  declare @i int;
  declare @c int;
  set @i = 0;
  set @c = 0;
  while @i <= len(@list)
  begin
    declare @n int;
    set @n = charindex(@delimiter, @list, @i);
    if 0 = @n
    begin
       set @n = len(@list);
    end
    insert into @shards (id, value)
      values (@c, substring(@list, @i, @n-@i+1));
    set @i = @n+1;
    set @c = @c+1;
  end
  return;
end


Than you can select from your function with different values. You have to join the ids to prevent from crossed results.

select split1.value, split2.value, split3.value, split4.value from
split('a,b,c', ',') as split1,
split('a,b,c', ',') as split2,
split('1,2,3', ',') as split3,
split('some,more,values', ',') as split4
where split1.id = split2.id
and split1.id = split3.id
and split1.id = split4.id

Is it a fixed count of columns you want to pass or is there a limit of i.g. 3 columns?

regards