January 11th, 2013, 09:16 PM
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?
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!