select a.RecID , a.PC ,

case when 100-sum(case when b.PC >a.PC then b.PC end) <20.0 then 0 else 1 end

from sums a, sums b

group by a.RecID, a.PC

rec16...

oops, sorry . upside down

To get the hits, try

select a.RecID

from sums a, sums b

where b.PC >=a.PC

group by a.RecID

having sum(b.PC) >= 80.0

If the table contains unique keys, you can keep the integrity of your extract without having to hold up other users:

- select keys to a temporary table;

- select...

Two ways suggest themselves

1. Keeping the current format

At the start of the sproc

select distinct substring (fdis_claim.claimset_id, 1,8) date into #temp1

FROM FDIS_CLAIM, FDIS_CLAIMSET

WHERE

FDIS_CLAIM.CLAIMSET_ID = FDIS_CLAIMSET.CLAIMSET_ID

AND...