I wonder how the 17% can think that a variable of type int can hold a "Error" value. May be null, but error?

By the way, what is the "Error" value?...

I learned this from self-experience some years ago, when I was testing one of my first sp's.

😀

And... what was the challenge?

😀

(Bob Brown) (10/5/2012)

---

Another confusing QotD! The answer is definitely 2,0. That is the results from the "selects". The "insert" errors out. It is very...

Good and interesting question. Thanks!

I also have had...

...there is another constraint to people that I hadn't considered. Each individual in your company isn't just a resource that's exchangeable for others. Each individual has knowledge and skills that...

It's good to start the week getting a sweet candy like this.

Thank's for the nice question 🙂

Olga B (9/6/2012)

---

It's great when that happens, isn't it.

Would you mind sharing what problem you had that was solved by CROSS APPLY? I haven't had a chance to use it,...

Hugo Kornelis (9/6/2012)

---

I'd put it differently. The only difference between CROSS...

mbova407 (9/6/2012)

---

I guess I don't understand the question. How is using cross-apply with a where join any different then an inner join with the ON (or where) join

SELECT

...

Not all the rules have an exception, unless you use table variables in transactions 😀

I'm glad I did my homework about table variables when I studied that theme.

Koen Verbeeck (9/3/2012)

---

W00t w00t, thanks for the 7 easy points Steve.

kaspencer (9/3/2012)

---

Just a bit too US-centric again.

What is Labour Day anyway?

You have an international membership, so you need to be...

Opposite of what happened yesterday, and still proudly, again I'm part of the 77%, but now with the right answer. Some days are better than others 😎

Yes! Proudly I'm part of the 73% that went wrong. :pinch: But I've learned something new, and now I know a little bit more of SQL of what I knew...