VbzCart/procs/Upd Depts fr DeptIttyps

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: Updates some fields in _depts after that has been filled in by Upd_Depts_fr_Depts_Suppliers
• Input: _dept_ittyps (group by ID_Dept)
• Output: _depts (update)

[edit] SQL

CREATE PROCEDURE Upd_Depts_fr_DeptIttyps()
    UPDATE _depts AS d LEFT JOIN (
      SELECT
        ID_Dept,
        SUM(di.cntForSale) AS cntForSale,
        SUM(di.cntInPrint) AS cntInPrint,
        SUM(di.qtyInStock) AS qtyInStock
      FROM _dept_ittyps AS di GROUP BY ID_Dept
      ) AS di ON di.ID_Dept=d.ID
      SET
        d.cntForSale = di.cntForSale,
        d.cntInPrint = di.cntInPrint,
        d.qtyInStock = di.qtyInStock;