SQL Optimization Case Study - JOIN Clause vs. IN Clause 

... WHERE id IN ( SELECT u.id FROM @users u )

For Cut-and-Paste