-
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.
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
|