math function - divide

[matt969]

I have the following query that I can't get to work...essentially I want to divide one count by another...can anyone help?


select count (*)
from R5events
where evt_completed <=evt_target
and evt_rstatus = 'C'
and evt_person = 'SMITH-MP'
/
select count (*)
from R5events
where evt_person = 'SMITH-MP'

 

[nigelrivett]

depends on the datbase. Try
select
(select count (*)
from R5events
where evt_completed <=evt_target
and evt_rstatus = 'C'
and evt_person = 'SMITH-MP')
/
(select count (*)
from R5events
where evt_person = 'SMITH-MP')

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[matt969]

Hey, that worked - with the addition of &quot;from R5events&quot; on the last line.

Thanks.

 

[dnoeth]

Sounds like a typical case for a CASE:

select
count(case
when evt_completed <=evt_target
and evt_rstatus = 'C'
then 1
end)
/ count (*)
from R5events
where evt_person = 'SMITH-MP'


Dieter