Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Depleting a Balance in a script

Author  Topic 

Starting Member

1 Post

Posted - 2005-12-22 : 09:48:23
I need some help quite desperately. Is it possible to deplete a amount through writing a SQL script. I have two tables, one with a line per JOB and a Invoice balance per JOB. The other table has many lines per JOB with amounts. I need to deplete the Invoice Balance in the first table against the Invoice amounts in the second table with a result of the calculation displayed in a seperate column. Is this possible?

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2005-12-22 : 10:59:48
Yes! And there are many examples out there on the web readily available. Search here or Google for this.

Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?
Go to Top of Page

- Advertisement -