Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » Ceiling, Floor and Round!
Add to briefcase
11 posts, Page 2 of 2
««12

Ceiling, Floor and Round! Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
KevinC.
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
11 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.