That was my thinking, too. Thanks, Steve. Enjoy London!

Nice question, Steve. I thought that the values in the third column would be different in each row, but I forgot that the seeds set the sequence for subsequent calls....

Woo-hoo! :w00t:I figured it out via some deductive reasoning (and possibly some luck). Like a lot of other people who are posting here, I had never heard of this, either,...

Excellent question, Sean, and fabulous explanation. It caught me off guard and made me go "WOW" when I read the explanation, because I usually don't like using semi-colons in my...

Nice question, Steve, thanks. I didn't know about those. When your question mentioned SQL Server 2014, I thought it was something new to 2014, but it looks like it goes...

I'm glad no one is flaming Steve for that typo. When you Google "mofified", it's amazing how...

twin.devil (10/16/2014)

---

Apologies everyone wrong radio button was selected ... Still wondering how.

As for the point, i would say ..

Sometimes in the real world, even if you are right you...

I think it's interesting to note that the article that Jaime linked to in BOL is only shown as being relevant to SQL Server 2005, 2008, and 2008 R2, even...

Stewart "Arturius" Campbell (10/15/2014)

---

Enough nitpicking.

yes, the question used a reserved keyword for a column name (purely by mishap, i'm sure).

but, despite that little inconvenience, the idea behind the question was...

Nice easy question to start the week. Thanks, Steve.

kevin 21984 (10/10/2014)

---

Just wanted to add something I actually like about THROW (although it's not compelling enough to use it everywhere). Basically THROW will give you the actual line...

Excellent question, Steve. I was sure that it was either the first or the fourth option; I just wasn't sure if the transaction would be rolled back automatically or not....

Nice question, Steve, thanks. I was familiar with Cross Apply, but not Outer Apply, although it makes sense for both to be available, and Outer Apply to be similar to...

Any engineer worth their salt should be able to see right through that trap and figure out a way to get the latte without getting trapped. 🙂

Of course, that assumes...

Thanks for the relatively easy question to start the week, Steve.