below86 (4/20/2015)

---

Both are reasons I started to try and use this in my code,...

TomThomson (4/18/2015)

---

Hugo Kornelis (4/15/2015)

---

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in the sales...

TomThomson (4/18/2015)

---

In the crazy case (crazy because providing an untyped null as the second argument of ISNULL isn't exactly a sane thing to do) where both arguments are untyped nulls...

The question is okay, but the explanation is absolutely incorrect.

The difference between the two functions is caused by some pretty non-standard behaviour of the ISNULL function. (Which is documented, by...

RLilj33 (4/15/2015)

---

On that note, I know that the ORDER BY clause is in general a performance killer. Can anyone speak to / point to a good article on /...

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in the sales table. (Or, if...

I hope you can reconstruct those, since they would be very interesting to look at....

TomThomson (4/9/2015)

---

Hugo Kornelis (4/9/2015)

---

What Matthew said.

I chose the answer that is marked as correct because that is the only one that really points out what is wrong - a column...

What Matthew said.

I chose the answer that is marked as correct because that is the only one that really points out what is wrong - a column list by itself...

This could have been a nice question about an interesting curiosity (though utterly useless, as nobody will ever use this in real life - right?).

Unfortunately, the mishap with the schema...

I copied the question text in Management Studio and executed it, and the result was an error message. If this only works on SQL Server 4.2, it should be indicated...

Eirikur Eiriksson (4/5/2015)

---

Try out this keyboard sequence:

😎

1. CTRL + H

2. [

3. TAB

4. ALT + A

5. ENTER

6. ]

7....

TomThomson (3/19/2015)

---

So far as dropping a database is concerned, there's an identical problem with dropping a table, so that part of the argument for not having cross-database foreign keys is...

How would you handle dropping a database, or...

Yes. See http://www.sqlservercentral.com/stairway/121631/%5B/url%5D

(Bit of work life balance issues at the moment, hope to...