yes, actually I have, and the problem is performance, one of the tables involved is pretty big with little way to narrow it down.
I'm looking to use the set all=pass to leverage the performance of a join. the set all=on setting works, and the problem is that I am parameterizing a field of the...
Actually, I've tried both ways, as well as with a ';' to no avail...
What does the leading hyphen do for me anyway, I've noticed while the conventions here (my place of work) seem to be to use it, on the forums, few people include it in their posts
thanks much
Hi
I've reac a couple of threads about left joins, and was hoping they would help in my current situation.
I thought that -SET ALL=PASS; would work to allow me to return unmatched records on a master table while using a where statement to govern the returns on the guest table.
unfortunately...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.