i have a query
declare @str as varchar(MAX)= '12,145,1598,1,5';
insert into rdmapping (itemid, rdid) values((Select value From String_Split( @str, ',')),100)
and getting an error
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.