Please start any new threads on our new site at https://forums.sqlteam.com. 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 

LTerblanche
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
http://www.insidesql.de
Heute schon gebloggt? http://www.insidesql.de/blogs
Go to Top of Page
   

- Advertisement -