CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jan 2013
    Posts
    90

    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.

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    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
  •  





Click Here to Expand Forum to Full Width

Featured