Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Decimal returning as Integer
Message
 
 
À
13/10/2010 09:08:40
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01485249
Message ID:
01485250
Vues:
38
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform