Garima Bansal

Garima Bansal

  • 1.9k
  • 234
  • 5.5k

Subquery returned more than 1 value. This is not permitted

Nov 9 2022 7:51 AM

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.
 

 


Answers (2)