SELECT homeScore, visitorScore,
 CASE WHEN homeScore > visitorScore THEN 1 ELSE 0 END AS visitorWins 
FROM Schedule

select * from
(
	select 10 as number union all
	select -234
) as t
where 1

quote:

---

Originally posted by Peso

What about ties?

---

E 12°55'05.25"
N 56°04'39.16"

---

quote:

---

Originally posted by Peso

With ties I meant when the game was a tie. HomeScore = 10 and VisitorScore = 10...

---

E 12°55'05.25"
N 56°04'39.16"

---

quote:

---

Originally posted by Peso

Yes. And how do OP think to handle that case?
In baseball there can never be a tie?

---

E 12°55'05.25"
N 56°04'39.16"

---

quote:

---

In Major League Baseball, games end with tie scores only because conditions have made it impossible to continue play. A tie game does not count as an official game in the standings unless it is finished later or replayed; however, individual player statistics from tie games are counted. Inclement weather may also shorten games, but at least five innings must be played for the game to be considered official; four-and-a-half innings are enough if the home team is ahead. Previously, curfews and the absence of adequate lighting caused more ties and shortened games. Also, with more modern playing surfaces better able to handle light rains, the process for calling or shortening a game due to weather has changed; it is more common than in the past to delay a game as much as 2 hours before a cancellation; also, a delay usually does not occur anymore until the rain is moderate-heavy and/or there is standing water on some part of the playing field.

In Japan's Nippon Professional Baseball, if the score remains tied after nine innings, up to three extra innings may be played before the game is called a tie. Some youth or amateur leagues will end a game early if one team is ahead by ten or more runs, a practice known as the "mercy rule" or "slaughter rule". Rarely, a game can also be won or lost by forfeit.

---

quote:

---

Originally posted by dinakar

SELECT homeScore, visitorScore,
 CASE WHEN homeScore > visitorScore THEN 1 ELSE 0 END AS visitorWins 
FROM Schedule

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

---

quote:

---

Originally posted by Peso

Same thing as Dinakar wrote 3 days ago...

---

E 12°55'05.25"
N 56°04'39.16"

---

quote:

---

Originally posted by arorarahul.0688

quote:

---

Originally posted by dinakar

SELECT homeScore, visitorScore,
 CASE WHEN homeScore > visitorScore THEN 1 ELSE 0 END AS visitorWins here should be homeWins 
FROM Schedule

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

---

SELECT homeScore, visitorScore,
CASE WHEN homeScore > visitorScore THEN 1 ELSE 0 END AS homeWins ,
case WHEN homeScore < visitorScore THEN 1 ELSE 0 END AS VisitorsWins
FROM Schedule

Rahul Arora
MCA 07 Batch
NCCE Israna, Panipat
HRY, INDIA

######################
IMPOSSIBLE = I+M+POSSIBLE

---

quote:

---

Originally posted by madhivanan

I think he corrected alias name

---

quote:

---

Originally posted by Peso

quote:

---

Originally posted by madhivanan

I think he corrected alias name

---

I think he wants a software bundle package.

---

E 12°55'05.25"
N 56°04'39.16"

---