Ya, he wasn't the only one last week. Hopefully this doesn't turn into 3 of us playing against teams with only 4 guys starting every week. :ermm:

Aaaand, everyone is in the win column now!

Not sure if it's more elegant or not, and it does tecnically use 2 selects, but you could use a subquery.

select case when result.max_rank = t.ranking then 'top' else 'bottom'...

Don't forget about the Thursday night game tonight (now with real refs!). Also Pittsburgh and Indianapolis are off this week so get those guys on your bench so you...

I was a fan of yours this week. 😀 I was a little worried after the morning games when I...

Well, it looks like there is only going to be one undefeated team in the league once Week 3 is over. And perhaps only one winless team as well....

He's (or...

Just a friendly reminder if you have any New York Football Giants or Carolina Panthers on your team that you want (or don't) to play for you this weekend, get...

Ray K (9/18/2012)

---

roryp 96873 (9/18/2012)

---

Ray K (9/18/2012)

---

In my office league team, both of my RB's (Ahmed Bradshaw and Steve Jackson) left their games with injuries. They combined for a...

Although...

JC-3113 (9/18/2012)

---

Hi roryp 96873

I had to modify the code as it does not like '-' in the database name so i bracketed them. I also concatenated the database name...

SequelSurfer (9/17/2012)

---

SequelSurfer (9/17/2012)

---

Steve Jones - SSC Editor (9/17/2012)

---

roryp 96873 (9/17/2012)

---

Ugh, that was a pretty rough week for me. I'm going to need a huge night tonight from a couple...

I wouldn't mind Matt Ryan throwing about 4 touchdowns to Tony Gonzalez. 😀

A full outer join might be what you are looking for

select isnull(o1.orderid, o2.orderid) orderid, o1.[date], o2.city

from order1 o1

full outer join order2 o2 on...

You can generate the SQL to look for the index you have in each of your databases by using something like this:

select 'select *

from ' + name + '.sys.indexes i

where...