VbzCart/docs/procs/Upd Depts fr DeptIttyps: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''': Updates some fields in {{vbzcart|table|_depts}} after that has been filled in by {{vbzcart|proc|Upd_Depts_fr_Depts_Suppliers}} ==SQL== <section begin=sql /><mysq...) |
imported>Woozle (more doc) |
||
Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Updates some fields in {{vbzcart|table|_depts}} after that has been filled in by {{vbzcart|proc|Upd_Depts_fr_Depts_Suppliers}} | * '''Purpose''': Updates some fields in {{vbzcart|table|_depts}} after that has been filled in by {{vbzcart|proc|Upd_Depts_fr_Depts_Suppliers}} | ||
* '''Input''': {{vbzcart|table|_dept_ittyps}} (group by ID_Dept) | |||
* '''Output''': {{vbzcart|table|_depts}} (update) | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE PROCEDURE Upd_Depts_fr_DeptIttyps() | <section begin=sql /><mysql>CREATE PROCEDURE Upd_Depts_fr_DeptIttyps() |
Revision as of 21:21, 8 March 2009
About
- Purpose: Updates some fields in Template:Vbzcart after that has been filled in by Template:Vbzcart
- Input: Template:Vbzcart (group by ID_Dept)
- Output: Template:Vbzcart (update)
SQL
<section begin=sql /><mysql>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;</mysql>
<section end=sql />