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

DBISQL Script Help Expand / Collapse
Author
Message
Posted Thursday, February 21, 2013 7:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 7:20 PM
Points: 1, Visits: 0
I am trying to write a script that would take a preset balance from the first day of the month and subtract a certain table until a zero balance is reached.

Then carry over the balance owed to the next business day, and so on until the balance is done.
Something like this:

@month, day (1) health_balance = 300

health_balance - chrg_tip_ttl = balance_owed

carry over balance_owed to health_balance

if health_balance_owed is > 300 then

minus chrg_tip_ttl

else if

balance_owed = 0 then

endif;


Any help appreciated
Post #1422845
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse