>Naomi, I question the judgment of this for anything more than a few items. Joining against a temp table/table variable/subquery/etc is the way to go.
I agree, of course. My colleague just found that limit and brought it to my attention - looks like it's not documented. Other than that, of course, using temp table with items is indeed much better.
If it's not broken, fix it until it is.
My Blog