Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Decimal returning as Integer
Message
From
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:
01485252
Views:
35
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?
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform