VbzCart/docs/procs/Upd DeptIttyps fr TitleIttyps

About

• Input: Template:Vbzcart (grouped by ID_ItTyp, ID_Dept)
• Output: Template:Vbzcart (replace)

SQL

<section begin=sql /><mysql>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;</mysql>

<section end=sql />