David Portas (11/18/2009)

---

Your SQL solution does not solve the problem because it is still possible to create an order in the Orders table without any corresponding Order_Item.

You suggested using a...

I already posted a solution to your "impossible problem". A foreign key, or a simple trigger, or one line of code in the insert proc, or any number of...

Elliott W (11/18/2009)

---

GSquared (11/18/2009)

---

Of course, this isn't a big deal. It's a minor difference. There are advantages and drawbacks either way. I see the advantages for Select...

Michael Valentine Jones (11/18/2009)

---

If the table you are selecting into will later have a clustered index created on it, it is usually faster to create the table first and insert...

Liger's aren't mythical. Just rare. Nat Geo had some great videos of a few of them. I think some of those...

To answer the original question:

Since Top without Order By isn't required to return the same data each time, this isn't a problem. It's just the way it is.

With nolock...

Yeah, that's what DateDiff does. It's how it's supposed to work. Always has been.

TheSQLGuru (11/18/2009)

---

I especially dislike having to use a GUI to tediously redo by hand things such as maintenance plans that I might quickly do in an open-source platform with a...

Lynn Pettis (11/18/2009)

---

You mean I have been hitting my head...

forumdog (11/18/2009)

---

I shouldn't have to say it. It is assumed. My requirement was what I stated. For you to assume otherwise is just being unhelpful and being difficult. Be a...

David Portas (11/18/2009)

---

GSquared (11/18/2009)

---

Then how...

A number of RDBMSs and languages have been built and are being used. They include Dataphor, Muldis and various other open source efforts. I'm not sure what problems you are...

You asked for real world examples of problems that can't be solved by SQL. I've given one already: the ability to enforce a constraint that an Order must contain at...

All information can be represented without nulls or anything like them and I don't recall that Codd ever said otherwise. Science, mathematics and logic were able to describe the real...

Thanks Phil. The workbenches you and Robyn used to post on simple-talk.com were a key factor in me learning SQL Server and...