carls
4Penny.net
Points: 3300

7/17/2018 2:01:35 PM

How to update using a cursor

* This article, and all our great SQL for Beginners documentation, Is available on the SQL for Beginners menu
I need to update the IV00102 table from a sum of the item quantities in the SOP10200 table.  I need to be able to do this for an individual item or all items.
 

 
4Penny.net
Version: Unknown or N/A
Section: SQL for Beginners
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3