Posted by Alexander Kuznetsov on 06/06/06 20:36

There are many ways to accomplish that. I would start with something
this (untested):

select pos.RegJrnID
from(
select * from t1 where TaxableAmount >0
) pos
left outer join
from(
select * from t1 where TaxableAmount <0
) neg
on pos.RegJrnID = neg.RegJrnID
where neg.RegJrnID is null

• Next in forum: Re: Question about returning a smalldatetime from a Function
• Prev in forum: Re: Question on Transaction Log Backups
• Thread view: Re: Challenge: Can you optimize this?

[Reply to this message]