shane.green 1227 (2/3/2015)

---

Good question, although the answer was given away because there was only one answer with "system database". If you had included system database into the list earlier...

Ed Wagner (2/2/2015)

---

SQLRNNR (2/2/2015)

---

I have to agree. ...

GilaMonster (1/29/2015)

---

That's kinda dumb. Instead of...

Admission?

mister.magoo (1/28/2015)

---

I have previously worked with a calendar table that maps out the financial periods to calendar dates, and an exchange rate table that holds spot rates based on currency...

Eric M Russell (1/27/2015)

---

andrew gothard (1/27/2015)

---

Eric M Russell (1/21/2015)

---

ProductID, ProductId, and product_id are all respectable options, so long as it's done consistently.

However, I would take issue with ID by...

Sean Lange (1/26/2015)

---

Oh the cursors are unbelievably stuipd. They are used to count!!!

set @Counter = 1

while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin

set...

The thing that makes me thingk neither schema will work is that forex rates dont change nicely at month boundaries. Any organisation that pretends they do will either run...

SQLRNNR (1/26/2015)

---

Grant Fritchey (1/24/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are...

Nice straightforward question.

Half the people who have replied so far think they can use a column filter to select rows, which is a bit startling; and more than four fifths...

ScottPletcher (1/23/2015)

---

TomThomson (1/23/2015)

---

I suppose if your dBMS is anccient enough that's excusable. But it...

Although I agree with you 100%, Hugo, I thinkyou are wasting your time (in much the same ways as I waste my time when commenting on this nonsense). People...

I suppose if your dBMS is anccient enough that's excusable. But it probably isn't...

Carlo Romagnano (1/22/2015)

---

Hugo Kornelis (1/22/2015)

---

Carlo Romagnano (1/22/2015)

---

Hugo Kornelis (1/22/2015)

---

Not too thrilled with this question. Lots of work and thinking for a feature that should have been deprecated and removed twenty...

Quite a nice question, but I agree with Hugo about the explanation.

An interesting point is that what the queries return depends on options. If ANSI_DEFAULTS is off, both will...