Count within a case

[timscronin]

Looking at below, it does not error out but also does not return what we are expecting

form_ind = case when (select count(*) from fdb_medication fm1 where fm1.gcn in (select distinct fm2.gcn
from medication_payer_mstr mpm inner join
fdb_medication fm2 on fm2.ndc_id = mpm.ndc_id))
<> 0 then ' ' else '(NF)' end

 

[ptheriault]

Tim,
I'm not 100% sure but I think your problme is this line.

<> 0 then ' ' else '(NF)' end

What happens if you do this

<> 0 then 0 else '(NF)' end

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

After further review disregard that post. it's not correct.

- Paul
- If at first you don't succeed, find out if the loser gets anything.