Posted by Terry Olsen on 09/19/07 21:45

I have a table in SQL Server that looks like this:

Name Status
---------------------------
Steve Complete
Steve In Queue
John Pending
John Complete
John Complete
Tim In Queue

I need to throw a query at this that will return the number of
"Complete"'s that each person has. So the result would look like:

Name Completed
----------------------------
Steve 1
John 2
Tim 0

Can anyone help out with what a query statement would look like to get
the desired output?


*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: time conversion hiccup
• Prev in forum: Re: SELECT * vs SELECT col1, col2
• Thread view: How to select count records that "contain" data?

[Reply to this message]