no doubt. I added the response because it didn't look like anyone said this and I thought it was pertinent for someone researching the question at some point in...

I can't imagine a loop would ever be better. In my personal situations where I have used a cross join, if your dealing with at least many thousands of...