ALTER PROCEDURE [dbo].[PoliciesGetSuspenseAmount] ( @PolicyHeaderPK uniqueidentifier, @SuspenseAmount decimal(18,2) OUTPUT ) AS SET NOCOUNT ON; SELECT @SuspenseAmount = COALESCE(SUM(AmountReceived), 0.00) FROM [dbo].[ReceiptDetails] inner join [dbo].[Receipts] on ReceiptFK = ReceiptPK WHERE ([PolicyHeaderFK] = @PolicyHeaderPK AND ReceiptTypeFK = 4)However, when I execute it it rounds my decimals to an integer. If the result should be 69.57 I get back 70.