I put the query for detecting overlapping dates into a function and then added this as a table constraint and this does the same job:

Function

CREATE FUNCTION CheckLocationsOverlappingDates()

RETURNS int

AS

BEGIN

...

dcdanoland (8/20/2012)

---

Jonathan AC Roberts,

Bad news - I've been unable to create an indexed view for your query. First I had a few problems creating a view with schema binding -...

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...