| Author |
 Topic  |
|
|
stahorse
Starting Member
42 Posts |
 Posted - 09/27/2012 : 09:14:44
|
Hi
I have
SELECT
[PolicyId] = MB.POLICY_ID
, [SwitchValue] = ISNULL(SUM(MB.TOTAL_AMOUNT), 0.00)
, [RequestedAmount] = ISNULL(SUM(BF.FEE_AMOUNT), 0.00)
, [AmountPaid] = ISNULL(SUM(BF.GLOBAL_FEE_TAKEN), 0.00)
FROM PR_MONEY_BFN MB
LEFT JOIN PR_BFN_FEES BF WITH (NOLOCK)
ON MB.POLICY_ID = BF.POLICY_ID
WHERE
-- ISNULL(BF.GLOBAL_FEE_TAKEN, 0.00) < ISNULL(BF.FEE_AMOUNT, 0.00)
--AND BF.GLOBAL_FEE_TAKEN < BF.FEE_AMOUNT
I don't get any data when I try to use: "BF.GLOBAL_FEE_TAKEN < BF.FEE_AMOUNT"
but when I use: "ISNULL(BF.GLOBAL_FEE_TAKEN, 0.00) < ISNULL(BF.FEE_AMOUNT, 0.00)" I get data back but with zero values for [AmountPaid] |
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2113 Posts |
|
|
stahorse
Starting Member
42 Posts |
Posted - 09/27/2012 : 09:29:40
|
I still get the same results, "BF.GLOBAL_FEE_TAKEN < BF.FEE_AMOUNT" doesnt return data at all.
"ISNULL(BF.GLOBAL_FEE_TAKEN, 0.00) < ISNULL(BF.FEE_AMOUNT, 0.00)" returns data but with only zero values for [AmountPaid] |
 |
|
|
lionofdezert
Aged Yak Warrior
Pakistan
864 Posts |
Posted - 09/27/2012 : 09:50:21
|
SELECT
[PolicyId] = MB.POLICY_ID
, [SwitchValue] = ISNULL(SUM(MB.TOTAL_AMOUNT), 0.00)
, [RequestedAmount] = ISNULL(SUM(BF.FEE_AMOUNT), 0.00)
, [AmountPaid] = ISNULL(SUM(BF.GLOBAL_FEE_TAKEN), 0.00)
FROM PR_MONEY_BFN MB
LEFT JOIN PR_BFN_FEES BF WITH (NOLOCK)
ON MB.POLICY_ID = BF.POLICY_ID
AND BF.GLOBAL_FEE_TAKEN < BF.FEE_AMOUNT
--------------------------
http://connectsql.blogspot.com/ |
|
|
|
stahorse
Starting Member
42 Posts |
Posted - 09/27/2012 : 09:58:07
|
| I'm getting zeros for all MB.POLICY_ID and MB.TOTAL_AMOUNT which is wrong. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
Posted - 09/27/2012 : 10:29:45
|
show some sample data from your tables and explain what you want as output from them
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
Where Clause Error
