Excellent, I have had to spin the selects round- but that works nicely.

Ian


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bob Levad
Sent: 17 April 2009 14:11
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Percent complete

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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Ian
Smith
Sent: Friday, April 17, 2009 7:34 AM
To: ADSM-L AT VM.MARIST DOT 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.
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.