The process of query optimization is very computationally expensive. For this reason, SQL Server stores execution ... this problem in the past: using nested stored procedures based on the value ...

I've got a couple many-to-many joins. I was wondering if a nested table is a better solution than simply creating an intersection table.<BR><BR>For example, MEASUREMENTS -- RESULT is many-to-many ...