Cantrell, Adam wrote: > Anyone know how to get this in SQLserver without two queries? I'm outputting > something like: "10 incomplete out of 23 for user Joe Shmoe". I know this is > totally wrong, but maybe someone will get my drift: > > <CFQUERY> > SELECT > tIncomplete.count(*) AS incompleteTasks, > tTotal.count(*) AS totalTasks > FROM TASKS AS tIncomplete, TASKS AS tTotal > WHERE > tIncomplete.num_peopleID = 184 AND > tIncomplete.bit_complete = 0 AND > tTotal.num_peopleID = 184 > </CFQUERY>
Datatypes? What is the definition of an incomplete task? What is the definition of a completed task? Jochem ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
