VbzCart/procs/Upd DeptIttyps fr TitleIttyps
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Input: _title_ittyps (grouped by ID_ItTyp, ID_Dept)
- Output: _dept_ittyps (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 />
