Posted by octangle on 06/06/06 20:59

Here's the tested (and slightly modified) version of your code...

SELECT pos.*

FROM
(
SELECT * FROM t1 WHERE TaxableAmount > 0
) pos
LEFT OUTER JOIN
(
SELECT * FROM t1 WHERE TaxableAmount < 0
) neg
ON pos.RegJrnID = neg.RegJrnID

WHERE neg.RegJrnID IS NULL

/* Make the results look pretty (optional) */

ORDER BY pos.RegJrnID

• Next in forum: Re: Record size more than 8060B
• Prev in forum: Re: Question about returning a smalldatetime from a Function
• Thread view: Re: Challenge: Can you optimize this?

[Reply to this message]