>>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?
>
>Are you testing this SP in SSMS or from .NET application? Also, try specifying the output to be bigger, e.g. 30,2 for now.
Testing in SSMS. Changing size of the output parameter to 30,2 made no difference