Programming Forums - View Single Post

myName · Sep 11th, 2006, 1:04 AM

declare @a decimal

select @a = SUM(A.Amt)-SUM( B.SubAmt)   
from [UA-FAM]..FAM_Txn A Join [UA-DSM]..DSM_Txn B
	ON( A.TxnID = B.TxnID)
where A.CardID IN (SELECT CardID FROM [UA-FAM]..FAM_CardAcct WHERE FAID = 9)
AND A.Status IN(1,5)
AND MONTH(A.DateCreated) = MONTH(GETDATE())

select ISNULL(@a, 0) A

Output:

Quote:

A
----
127

Problem:
The expected result should be 126.98.
Why the output is converted to 127????