Hi,

I have this stored procedure:

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.

What have I done wrong?