Steve Jones - SSC Editor (7/6/2012)

---

Pettite and CC out, and the Yanks still near the top of MLB : http://espn.go.com/mlb/standings

And the Rockies are officially in the doghouse. Tied for the...

The IIF function.

My most recent edit in the previous post will get you that. Sorry for...

Replace returns a null if any of the arguments are null, which is why you get nulls for everything in your query. You could do something like this:

SELECT

Test,

nullif('',...

So this then?

dateadd(month, datediff(month,'19000101',dateadd(day, 90, CURRENT_TIMESTAMP)),'19000101')

You just want to add 90 days to what that returns?

dateadd(day, 90, dateadd(month, datediff(month,'19000101',CURRENT_TIMESTAMP),'19000101'))

Welsh Corgi (6/28/2012)

---

I just checked and none of the CASE Statements are updating all of the records.

Does anyone have an example of a Sercehed CASE Statement used to perform UPDATES.

One...

I don't know if you want this behavior or not, but since your last two cases don't have elses, it will set those fields to null if Field2 does not...

If this play doesn't get MLB to look into using replay, I don't know what will...

Like Jared said above, I can't test this without any sample data, but give this a try and see if it works. If not you can try to play...

achen9291 (6/27/2012)

---

Select ClientUserName, DestHost, count(DestHost) counts from #ProxyLog_record

where ClientUserName =(Select top 1 ClientUserName from #ProxyLog_count_2) Group by ClientUserName, DestHost order by counts desc

I...

And what are you ordering by to determine the second row?

I see Tanyon Sturtze made it to the roster of the Yankees upcoming Old Timers Game.[/url] I was also surprised to see Strawberry on there. I guess I...

Markus (6/20/2012)

---

roryp 96873 (6/20/2012)

---

Markus (6/20/2012)

---

Cool....

Speaking of Minor league baseball look at THESE stats:

Billy Hamilton, low Single A for the Cincinnati Reds.

66 games and 80 stolen bases!

I know......

Markus (6/20/2012)

---

Cool....

Speaking of Minor league baseball look at THESE stats:

Billy Hamilton, low Single A for the Cincinnati Reds.

66 games and 80 stolen bases!

I know... it is Single...