very useful as I'm struggling with exactly the same problem:

a storeed procedure that joins two tables based on a selection from one table that can return as few as 50 rows or as many as 2 million!

I will test this and see how it runs.