-
January 11th, 2013, 10:16 PM
#1
Division in SQL Server
All sources I found today say that if I need to divide one value let's say Profit on another one, let's say Selling price (markup), I need to use / operator, so:
Select Profit/SellingPrice AS Markup from...
By some reason I always get ZERO when Profit is smaller than SellingPrice.
Both columns in the table are MONEY type, not integers or something like that
Why is that?
Thank you.
-
January 12th, 2013, 03:44 PM
#2
Re: Division in SQL Server
If you searched with Google for Division in SQL Server money you'd see that you were not the first who had got this problem...
https://www.google.com/search?q=Divi...w=1120&bih=620
Victor Nijegorodov
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|