Ugh, starting a fantasy draft at midnight? I don't think they get the following Monday off either like most of us in the States will have do they? ...

September 2nd (this Sunday) at 4pm Pacific/7pm Eastern. The folks across the pond are going to have to convert that time themselves. 😛

Unless the Dodgers win the Series this year, it seems obvious to me that the Sox are the winners....

Probably because no one will pay attention to them unless they say something stupid. Half the time I think guys like Bayless and Limbaugh do this as a character,...

That crazy lunatic who wanders onto ESPN sets from time to time and goes...

calvo (8/22/2012)

---

off topic .... duh! This thought crossed my mind...

Lowell (8/22/2012)

---

Local radio station recently said that people in a Fantasy Football League average 10 hours per week on Fantasy Football?

Is that an exaggeration or do you think that is...

Sounds good. Post back if you need any clarification or additional help. This link would be a good place to start.

A cte with a row_number should help you. I can't test since you don't have sample data, but let me know if it does what you need and if...

That is a good point. I was just trying to say that this could be Washington's best shot at a WS in 10 years or longer. Why they...

I'm not really sure who it is since this is my first year and I can't really tell by some of the yahoo user names. SQLDCH should have a...

Well, it looks like we are only about a week and half from the draft and we have an odd number of teams in the league. Is our final...

calvo (8/22/2012)

---

How about this recap...

-The Rocket it back (in the minors)

-Carl Crawford is out for Tommy John surgery (surprise!)

-Strasburg is reaching his innings limit (while the Nats have the best...

I think just doing the self join (the left join) on MEMBID and the row number to row number + 1 will solve the problem in the second set of...

Try something like this:

select CONVERT(date, mydate, 103)

from mytable