select DISTINCT (100.0*(Select count(*) from events where scheduled_start >current_timestamp - 1 day)/(Select count(*) from events where status not like '%Completed%' and scheduled_start >current_timestamp - 1 day)) AS "Percent" FROM events
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Ian Smith Sent: Friday, April 17, 2009 7:34 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Percent complete Hi I need a little reminder on how to do a calculation in a SQL statement: I want to divide: Select count(*) from events where scheduled_start >current_timestamp - 1 day BY Select count(*) from events where status not like '%Completed%' and scheduled_start >current_timestamp - 1 day THEN * 100 I have done this before by putting each statement in brackets but can't quite remember!!! Thanks Ian Dell Corporation Limited is registered in England and Wales. Company Registration Number: 2081369 Registered address: Dell House, The Boulevard, Cain Road, Bracknell, Berkshire, RG12 1LF, UK. Company details for other Dell UK entities can be found on www.dell.co.uk. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
