|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
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
Other interesting topics
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 |
|||||||||||||||||||||||