Re: Moneyball....

The lessons applied were not just in talent evaluation, but also tactical decisions while playing the game. Statistical analysis showed that outs are often under-valued and so Oakland...

My answers would include back to school for more in-depth understanding of early-childhood development, then using that knowledge to promote programs for training parental skills.

I suppose the big question...

SQLRNNR (1/11/2012)

---

Evil Kraig F (1/11/2012)

---

Is it bad I originally misread the link and thought it said 'sex frustrations' as the folder?

😀 I've been tempted...

Catching up with SSC upon return from vacation (er, "holiday" for you non-Americans).... Interesting span of response to the US-Centricity of this QOD. Just to fill in...

As Phil suggested, it would be helpful to see...

Phil's given you a basic "group by" structure that will return the totals for each year. You gave us only 2011 data, but it'll break out other years too. ...

Ron (AKA Bitbucket),

You were spoiled having as much as 32K (I assume bytes) to work with, let alone be able to chain to multiple segments. I'm certainly not old...

After finding the BOL doc that warns against naming a procedure with an "sp_" prefix, I wonder if the precedence rules are controlled by another factor besides the prefix and...

Hugo Kornelis (12/14/2011)

---

This actually makes the behaviour even more weird, since (according to the documentation for SQL Server 2005 - I see the relevant comments have been removed from...

Not nearly so long.... pitchers and catchers report as early as 2/18, depending on the team. See http://springtrainingonline.com/features/reporting-dates.htm

Christian Buettner-167247 (12/13/2011)

---

john.arnott (12/12/2011)

---

So nearly two-thirds of respondants so far are smarter than I. They wouldn't have just run the code and clicked the corresponding option now, would...

So nearly two-thirds of respondants so far are smarter than I. They wouldn't have just run the code and clicked the corresponding option now, would they?

Anyway, I ended...

Mark,

Is the error message completely unambiguous? Or is it possible that some other column is what's getting truncated? "Truncation" makes it sound like a character type....

Thank you Gail.

Using sp_Help removes any doubt. The datalength seemed like strong evidence, but this is more clear.

I've not tried anything to prove this, but it seems that if you 're converting a string to DT_DBTime, the string should be in the format of hh:mm:ss. If...