Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rounding up in SQL Server
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00775316
Message ID:
00775320
Vues:
14
This message has been marked as the solution to the initial question of the thread.
Hi Alan,

Just add .0049
Select ROUND(2128.0748 + .0049, 2)
>Hi,
>
>I need to do some rounding to 2 decimal places - but I need to round up and I'm not sure how to get the results I'm looking for.
>
>For example:
>
>
>Select ROUND(2128.0748, 2)
>
>returns 2128.07
>
>
>
>I want it to return 2128.08 - any ideas on how to go about achieving this result?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform