Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Ceiling, Floor and Round! Expand / Collapse
Author
Message
Posted Wednesday, October 28, 2009 12:16 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 12:55 AM
Points: 771, Visits: 504
I'm sure someone else can post it more elegantly, but here's a quick solution:

select cast(round(123.45 * 1.07,2) as money)

I based it off of slange-862761's suggestion of using cast in an earlier post.

I don't know if this helps at all, but it might point you in the right direction.

--
Kevin C.
Post #810209
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse