p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Professional Microsoft SQL Server 2008 Programming (http://p2p.wrox.com/book-professional-microsoft-sql-server-2008-programming-499/)
-   -   Get Completed Boxes from a table (http://p2p.wrox.com/book-professional-microsoft-sql-server-2008-programming/87827-get-completed-boxes-table.html)

ricespn June 24th, 2012 01:33 PM

Get Completed Boxes from a table
 
Hi guys,

I have the folloing table:

docID, boxNumber, docCompleted

1235, box01, true
1234, box01, true
1233, box01, false
1245, box02, true
1987, box03, true
1097, box06, false

I'm trying to use a Distinct to display the box number that have been competed. If I do my query like so:

Code:

Select distinct(boxNumber) from table1 where docCompleted=true
but that will list box01 even tho one docID (1233) is not completed.

Any help ?

ricespn June 25th, 2012 02:40 PM

Man Really, no one?. Thats the reason I dont like to post in forums. Everyone are looking for help but so little helpers.

[:)]


All times are GMT -4. The time now is 08:19 PM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.