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.
