brian lewis (5/7/2010)

---

... the central idea here does give another way to calculate a MEDIAN - sort for row_number on the value you are interested in (possibly including an ID...

Dan Guzman - Not the MVP (5/7/2010)

---

Nuke-ware: Only certain features actually work. press the wrong button, or in the wrong order, and the whole thing may crash/fail/take down...

Good question, great discussion. Very interesting problem. I definitely learned a lot today, including to watch how I set up ad hoc queries.

Thanks!

Jeff Moden (4/24/2010)

---

Heh... supposed time wasted in meetings is the least of my worries. A bazillion emails and IM's are a total waste of time compared to the productive...

David Walker-278941 (4/19/2010)

---

This article, like many discussions of Cross Apply and Outer Apply, says "APPLY is named after the process of applying a set of input rows to a table-valued...

bwillsie-842793 (4/16/2010)

---

I knew one startup business owner who made it a point of standing at the door at quiting time on Friday afternoon and personally thanking each employee for the...

Paul White NZ (4/12/2010)

---

There are some notes on this in the attached scripts - but essentially, no it...

From MS SQL documentation:

datetime: January 1, 1753, through December 31, 9999

smalldatetime: January 1, 1900, through June 6, 2079

Note:

datetime is stored as two 4-byte integers for days from 1/1/1900 and...

Thanks for a good article. I've been using the CONVERT(CONVERT) technique mentioned by lhowe.

lhowe (4/7/2010)

---

Another method to strip the time from a date/time value and keep it as a...

Paul,

Good question, great discussion, especially about the execution plans. Glad to hear that ANSI NULLS OFF will be deprecated. (scary stuff!) (My gut feeling was that it was...

Sanjay,

Thank you for the excellent reference, and its explanation of "Why 1753".

-c

Performance Tuning and SSIS.

Ok, while I can order at Chipotle fairly quickly, I admit I am the person in the burger joint who has to read the whole menu (oh, isn't there anything...

Anders,

Thank you for a really nice, step-by-step walk-through.

Looking forward to giving it a try.

How about adding this: round(3.5678,1,1)