L' Eomot Inversé (10/31/2011)

---

Steve Jones - SSC Editor (10/31/2011)

---

A fun question for a holiday. At least it was supposed to be for me, but a little behind.

It's a bit of...

Great question????!!!!!

How is knowing this going to help me in my career?

Please let's avoid pointless questions like this in future! It was pointless, quite literally, for me...

Enjoyed that one.

Just a little surprised that the explanation seems a little brief and misses out the key point of precedence.

Whilst I wasn't sure what the precedence was,...

Oh dear. I got it right, but the answer said I got it wrong!

Incidentally, I'm running the dinosaur that is SQL Server 2005 and so I had to modify...

Hardy21 (1/4/2011)

---

cengland0 (1/4/2011)

---

Hugo Kornelis (1/4/2011)

---

I replied wrong - I saw the rollback after the truncate, assumed the question intended to test my understanding that a truncate can be rolled back,...

SanDroid (12/14/2010)

---

phil.wood 94423 (12/13/2010)

---

SanDroid (12/10/2010)

---

Most QOTD readers that actually run or test the QOTD scripts do so in a default...

SanDroid (12/10/2010)

---

Most QOTD readers that actually run or test the QOTD scripts do so in a default NON Production installation...

The code returns an error:

Msg 3701, Level 11, State 5, Line 1

Cannot drop the table 'dbo.NullOperation', because it does not exist or you do not have permission.

The table is created...

That'll teach me to shoot before I aim.

Thanks

Oops, I got it wrong.

In my defence, nesting works all over Microsoft so I'm a little surprised they never got it working here. Almost seems like an oversight.

Would have...

How about good ol' grouping to remove duplicates and supply any of the minimum, maximum, sum, count, average, etc. etc?

select ItemNumber, min(UnitCost) as MinCost from MissingItems

group by ItemNumber;

ItemNumberMinCost

77710.10

88813.13

99916.16

I agree - don't awaken the beast.

In the eyes of developers, cursors are like Marmite.

The author has made their mind up before putting this to press (as shown in the naming convention 'badCursor' and the article title 'Cursors Be Gone!').

The author has, however, totally...