I've just knocked up a quick solution to the overlapping dates problem.

I have a table Locations for which the column LocationCodes must not have overlapping dates. A datetime of NULL...

So in summary:

If you have an integrity rule that you want to enforce on a database and you can write a query that returns one or more rows if there...

Nice article but a few charts of what the distributions look like would have been nice.

Who told you that?!

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

I didn't realise that, I thought it was open source and anyone could use it.

Where does it say that...

Lisa Slater Nicholls (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

I didn't realise that, I thought it was open source and anyone could use it.

Where does it say...

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

I didn't realise that, I thought it was open source and anyone could use it.

Where does it say that you can't use it for...

michael vessey (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

michael vessey (6/1/2012)

---

If you are supplying SQL Server have multiple vendors and using SPLA licenses the cost is not far off $1,000 per cpu per...

michael vessey (6/1/2012)

---

If you are supplying SQL Server have multiple vendors and using SPLA licenses the cost is not far off $1,000 per cpu per month for enterprise edition, possibly...

michael vessey (6/1/2012)

---

You could get a multiprocessor SQL Server machine with a $1000 a month per cpu license fee or you could find an open source database that would do...

IceDread (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql server, you certainly do not want...

michael vessey (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql...

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql server, you certainly do not...

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql server, you certainly do not want to go to Oracle...

I copied and pasted the function from the article but it wouldn't compile. There were some CHAR(63) in there instead of CHAR(32) (spaces)