Haha, good start into a friday 🙂

From my experience, queries indeed sometimes have different execution plans when switching between ON and WHERE clause.

But I am pretty sure that there is no preference for one or...

Hope this doesn't sound stupid, but I would simply test it and compare both versions.

Make sure you rebuild the table or clustered index after adding / removing the columns.

I just did a quick check here and got the same issue as you with the Oracle OLEDB Driver.

The microsoft driver works for me so this might be an option...

Can you check if you use the proper case? (lower case / upper case)

Nice one!

And I also have a question: During execution of the batch, I get a warning:

XML DTD has been stripped from one or more XML fragments. External subsets, if...

emamet (7/8/2008)

---

Christian,

Is it not "part of the fun" to sometimes get it "not entirely right"?

I actually find the debate as interesting if not more interesting than the original question and/or...

Hugo Kornelis (7/8/2008)

---

Christian Buettner (7/8/2008)

---

In general an interesting question, but it is simplified a little too much. Cursors are such a complicated construct with so many nested options and dependencies...

In general an interesting question, but it is simplified a little too much. Cursors are such a complicated construct with so many nested options and dependencies on the requirements, so...

Truly deserved. Congrats! And keep up the good work!

I agree with Peter. There are always going to be errors. But many errors can be prevented if QODs are validated by an independent "tester".

I would like to see...

Thanks Steve! (whoops, here it would have been my 2nd point ;))

Thanks liam, I think I made it too obvious 😉

Good Question - Straight forward, no pitfalls, a good start into the day 🙂

I also missed that one because of the TIMEOUT. But re-reading the question revealed that the question writer had this in mind when choosing his wording.

Tricky 🙂