Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Create sum closest to an integer Expand / Collapse
Author
Message
Posted Wednesday, July 31, 2013 2:28 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:48 PM
Points: 2,397, Visits: 3,406
Need OverSum and UnderSum calculations?
See http://weblogs.sqlteam.com/peterl/archive/2008/08/12/How-to-sum-up-an-unknown-number-of-records.aspx
and http://weblogs.sqlteam.com/peterl/archive/2008/11/23/Bin-packaging.aspx



N 56°04'39.16"
E 12°55'05.25"
Post #1479694
Posted Thursday, August 1, 2013 6:52 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:44 AM
Points: 411, Visits: 267
I am sorry, I am not sure I understand the question.
I need for the sum created, to be closest to a given number (10, in the example above), but not go over it.
Post #1479918
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse