How can I make this query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How can I make this query

Author

Topic

pagino
Starting Member

4 Posts

Posted - 2009-01-20 : 22:18:00

Hey gang .. how could I build a query that would display the standings table below:

Team Wins Losses Ties
Sharks 1 1 1
Ducks 0 2 0
Lightning 1 0 1
Wild 1 0 0

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-21 : 01:26:58

We have answered at least four similar questions before.
Try a search for "Win Loss Tie".

E 12°55'05.63"
N 56°04'39.26"

pagino
Starting Member

4 Posts

Posted - 2009-01-21 : 13:30:21

Thanks for your reply ..
I tried looking, but this is the only one I found:
http://weblogs.sqlteam.com/jeffs/archive/2008/04/23/unpivot.aspx

What is your opinion of a table schema as the one provided above ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-21 : 16:15:16

Try this
http://www.sqlteam.com/FORUMS/topic.asp?TOPIC_ID=87759

E 12°55'05.63"
N 56°04'39.26"

pagino
Starting Member

4 Posts

Posted - 2009-01-21 : 18:24:44

Ok .. awesome .. thanks a lot.

Pagino

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources