Hi Michael,
There appears to be a much smaller limit in the ON clause than in the WHERE clause. I don't have the specifics in front of me, but 5 conditions seems about right. Even when I maxed out the memory via sys(3055) I ran into this. Sorry.

>Is there a limit to the # of conditions you can specify? The query is running fine now that I changed it, but as soon as I add the 5th filter I get "There is not enough memory to perform this operation" error.