VbzCart/docs/procs/Upd DeptIttyps fr TitleIttyps

About

• Input: Template:Vbzcart (grouped by ID_ItTyp, ID_Dept)
• Output: Template:Vbzcart (replace)
• History:
  • 2010-11-10
    • Added DROP PROCEDURE for easier maintenance.
    • Created in database (procs were not ported from L48 to Rizzo).

SQL

<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_DeptIttyps_fr_TitleIttyps; 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 />