I have a batch system where the user enter suppliers invoices to a batch table (SupVchBat)
then selectively update certain invoice to outstanding invoice table (SupVch) and updated
suppliers (Supplier.sup_mtdpur) current balance and warehouse (warehouse.WHS_ MTD_SALE).
Such is done currently in the front end using VB, but the process is very slow hence I need
help to write batch update in back end using mssql. You help is highly appreciated.
Tables structure is as follows:
TABLE [SupVchBat] (
[vbat_whs_code] [nvarchar] (3),
[vbat_sup_code] [nvarchar] (4),
[vbat_vch_no] [nvarchar] (6),
[vbat_sup_vch_no] [nvarchar] (10),