This is why I never use aproximate values.

Being in a financial field, I've never really had the need to use those.

I believe this is the actual reason why we get that result. Can...

...Even if a rowset were returned, the the rowset could be sorted as the last action of the select statement, ie after the assignment, so not assigning the value from...

Of course. I learned that lesson a looooong time ago 😀

Sean Lange (7/29/2015)

---

SqlMel (7/29/2015)

---

Good question and something to keep in mind always.

I ALWAYS use Top 1 when assigning values to...

I mostly do this to read parameter values that I have set up in tables so in all the cases I can think of I only get returned one row...

Good question and something to keep in mind always.

I ALWAYS use Top 1 when assigning values to variables even though in all cases I can think of I use a...

Agree.

Richard Warr (7/28/2015)

---

Also a good illustration of why NOT IN can be very risky. Using NOT EXISTS instead gives the result that would probably be intended in this scenario:

SELECT Value

FROM...

Thanks for the question.

Good day to all.

Too bad you couldn't make it. There were some great sessions.

I knew I had this from the start since I've made the mistake of not putting the GO statement before calling the SP, as shown in batch 1.

After that, it...

sestell1 (3/23/2015)

---

Rune Bivrin (3/23/2015)

---

Can't really say anything positive about a question which relies on regional settings for correct answer, and which doesn't really promulgate any useful knowledge. Why would I...

Thanks for the question, Steve.

Thanks for the question.

Glad to see over 80% got this right (so far)

Very good question, Tom.

It was easy for me since I knew beforehand that the foreign key would be ignored and the temp table would be created.

Hope to see more questions...