In my experience it is always faster to join with "exists" then do a painful "in". "In" is only good for several values. With ssis, you can actually...

Well, the question was whether there is another solution. So there might be many, you just have to say, "Yes". As mentioned above, there are plenty, including "union",...