I'm trying to find all records in a table based on two parsed strings. The first parsed string will be a series of IDs that need to be matched up to the IDs in the table. The problem is that the IDs in the table are in one field that need to be parsed as well. I've created a function fx_ParseString that will parse the string for me already. So far I have the following SQL Script:
WHERE (SELECT * FROM fx_ParseString(IDs,'/')) IN
(SELECT * FROM fx_ParseString(@IDs,'/'))
When I run this I get the following error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.