DBISQL Script Help

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » DBISQL Script Help

DBISQL Script Help

Rate Topic

Display Mode

Topic Options

Author

Message

rouen5

Posted Thursday, February 21, 2013 7:25 PM

Forum 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 »

Permissions