VbzCart/procs/Upd DeptIttyps fr TitleIttyps

From HTYP, the free directory anyone can edit

[edit] About

• Input: _title_ittyps (grouped by ID_ItTyp, ID_Dept)
• Output: _dept_ittyps (replace)

[edit] SQL

CREATE PROCEDURE Upd_DeptIttyps_fr_TitleIttyps()
  REPLACE INTO _dept_ittyps(ID_ItTyp,ID_Dept,cntForSale,cntInPrint,qtyInStock)
  SELECT
    ID_ItTyp,
    ID_Dept,
    SUM(cntForSale) AS cntForSale,
    SUM(cntInPrint) AS cntInPrint,
    SUM(qtyInStock) AS qtyInStock
  FROM _title_ittyps
  GROUP BY ID_ItTyp, ID_Dept;