I made it kind of policy not to play games in the office. I find it offending to "play around" while others are doing actual work. Instead, I'll use the...

c) Are used in the where clause

In case of...

I very much liked it when the phenomenon of the Balanced Score Card was introduced in one of my previous jobs. It is a good way to get rid of...

Strangely enough, it rarely takes me longer than planned to travel somewhere. Even before the era of travel planners, I always managed to estimate a good ratio between distance and...

What has SSC NOT done for me ?

As a marketing guy and responsible for a CRM implementation I felt the need for better reporting possibilities than what the out of...

The geothermal option is now being implemented widely over here in The Netherlands. Almost any application for a building permit for new offices is accompanied by an application for a...

Hi Steve,

horse menure is a notoriously good heat source and you seem to have plenty of it around. It's being used in greenhouses a lot. The mass itself can reach...

I'd burn 5 MP3-CD's holding the complete works of

Pink Floyd

Led Zeppelin

Creedence Clearwater Revival

Queen

AC/DC

Keeps me going on those long trips from Holland to Poland and back....

I was born 40 km north of Amsterdam, went to school and later attended college there. Dreamed most of my youth about living and working all over the globe, but...

Here's another one for you:

I'm pretty sure that in some cases, professional sellers skim auctions on Ebay for items offered by private persons that are fairly current but that would...

I have had bad (performance) experiences with actually storing pictures IN the database. Although most DB manufacturers claim it can be done, my option of choice is still to store...

That would be my suggestion too, but I would swap steps 2 and 3

Erwin Rommel

Gentleman, visionaire, creative thinker, true leader, always on top of things and always at the spearhead of operations. "Where Rommel is, is front"

The man could easily have been a...

Thanks.

I don't have access to SQL Query analyzer at the moment.

The IN looks like the way to go if the list of values becomes a bit longer.

Happy holidays

Jurriaan

SELECT

TEAMNAME,

(SELECT COUNT(*) FROM TEAMRESULTS WHERE TEAM_ID = TEAMS.TEAM_ID) AS ITEMS_TOTAL,

(SELECT COUNT(*) FROM TEAMRESULTS WHERE TEAM_ID = TEAMS.TEAM_ID AND ITEM=VALID) AS ITEMS_VALID,

(SELECT COUNT(*) FROM TEAMRESULTS WHERE TEAM_ID = TEAMS.TEAM_ID AND ITEM=INVALID)...