Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Decimal returning as Integer
Message
 
 
To
13/10/2010 09:19:41
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01485249
Message ID:
01485258
Views:
38
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?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform