See the rest of the thread. Basically I needed to CAST as decimal(18,2), but now the stored procedure is returning the correct value 69.57, but the value getting into my C# code is 70.

>I don't see why it would round result. Are you sure about that? Where do you see rounding (SSMS)?
>
>
>>Numeric(18,2)
>>
>>>What is the type/definition for AmountReceived column?
>>>
>>>>
>>>>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?