Bruce Jenkins, a BWA member and HOF voter, makes his case for eight guys (written just before this year's announcement, so Alomar and Blyleven are on his list).

...

Uh, what was the question? 😉

Seriously, though, please restate the starting point so that others can learn from the discussion. That...

I cannot recall ever using smalldatetime, and now this QOD gives me good reason to avoid it. A max value in year 2079 implies that anyone attempting to save...

Although you may never have to simply swap the values of...

Now that we can store dates earlier than 1753, there should be no error storing them, but it seems that it will be up to an application using those dates...

OCTom (12/22/2010)

---

My 2 cents worth:

When correcting/criticising someone:

1. Don't make it personal.

2. Make it about the code and/or advice.

3. Use positive instead of negative terms.

4. Give an alternative and explain why...

cengland0 (12/16/2010)

---

Carlo Romagnano (12/16/2010)

---

It depends on "Regional...

Since the error is due to the #tmp table no longer being in scope once the EXEC() is done, one could fix this to work by making the table global...

I'm with UMG on this one. Besides the quibble that the WHERE clause...

How much more efficient is the proposed solution ORDER BY CAST(DATENAME(mm,SomeDateTime) + ' 1900' AS DATETIME)than adding a numerical representation of the month, whether by using MONTH() or DATEPART(), to...

Hugo Kornelis (11/9/2010)

---

john.arnott (11/8/2010)

---

Hmmm. When I run this code to build the table, "Select 1 from #test" returns two rows, each with a "1". It's an implied join,...

SanjayAttray (11/8/2010)

---

Create Table #Test (a int, b int, C as a+b )

go

insert into #test values (3,4)

insert into #test values (1,7)

go

select * from #test

order by 1

go

drop table #test

go

Isn't it funny...

Bazzkar,

With so many comments on your QOD, you really should be happy about it. Despite it perhaps causing some transitory embarrassment, you've engendered a lively discussion. Even though...

Or, if your locality sets the date format as dd/mm/yyyy, then would not the 01/07/2010 row be saved as first of July? That would seem to still result in...

The good thing is that I learned somethng here, and not about conversion precedence.

I answered that the intial assignment would fail as the CONVERT function seemed wrong. The...