Mighty (11/8/2013)

---

paul.knibbs (11/8/2013)

---

I kind of agree with waxingsatirical...it never occurred to me anyone would think this works otherwise, and I spent a good few minutes trying to figure out what...

Rune Bivrin (11/8/2013)

---

Ford Fairlane (11/7/2013)

---

Very good question - got caught out with as well. Should have realized that with out the where clause that each max() is evaluated individually... nice...

Indeed, sometimes the basics need to covered. Whilst really technical questions are great, the more commonly used functions are...

type, status etc are key words in SQL you might want to try putting square brackets round those columns. eg.

SELECT...

Hmm, quite a misleading title there. ***SO*** what would have happened if the previous nights data had not been acceptable? The DBA would have been responsible...:w00t:

RE : SQL 2000. I've been telling a client for more than 6 months that they should upgrade their server and move to at least SQL 2005. This...

Depending on what you want the documentation for you may want to add some initially hidden descriptive text to each report outlining what it does. you could make this...