 <p>I would suggest you to send a TVP (table value parameter) back to the server. After that your query could be done like:</p> <pre><code>SELECT p.ProductId, Name, Description, {other columns} FROM Products p left join @ExceptedProducts ep on p.ProductId=ep.ProductId WHERE where ep.ProductId is null </code></pre> <p>This should be the fastest and cleanest way.</p>