I have this calculation in which I have to reverse a negative number. I am
trying this syntax to no avail. Can someone give me an alternative or do I
have to CASE out all my subtotal buckets???

Any help is greatly appreciated.

Thanks!

    ISNULL(DERIVE7.total,0) +
    ISNULL(DERIVE8.total,0) +
    CASE WHEN DERIVE9.total IS NOT NULL
        THEN    (DERIVE9.total * -1)
        ELSE    0                'Net Lender Fees'




wnfisba

How to compare two tables of same structure using a hash/checksum
Encrypting in SQL Server 2005 to hide data for sysadmin?
how can this be done
Verify a SQL Server 2000 login
Using REPLACE
simple query
SELECT/INSERT SELECT performance issue
CASE in a UDF
Query to get a comma separated list of item2 grouped by item1
Help with grouping and selection