VbzCart/docs/procs/Upd Titles fr TitleIttyps: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | procs
Jump to navigation Jump to search
imported>Woozle
(changed source to eliminate recursive loop)
imported>Woozle
(corrected input documentation)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': Updates some fields in {{vbzcart|table|_titles}}
* '''Purpose''': Updates some fields in {{vbzcart|table|_titles}}
* '''Input''': {{vbzcart|table|_title_ittyps}}, grouped by ID_Title
* '''Input''': {{vbzcart/query|qryCat_Titles_Item_stats}}, grouped by ID_Title
* '''Output''': {{vbzcart|table|_titles}} (update)
* '''Output''': {{vbzcart|table|_titles}} (update)
* '''History''':
* '''History''':

Revision as of 21:51, 24 December 2011

About

SQL

<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps; CREATE PROCEDURE Upd_Titles_fr_TitleIttyps()

 UPDATE _titles AS t LEFT JOIN (
   SELECT
     ID_Title,
     SUM(ti.cntForSale) AS cntForSale,
     SUM(ti.cntInPrint) AS cntInPrint,
     SUM(ti.qtyForSale) AS qtyInStock
    FROM qryCat_Titles_Item_stats AS ti GROUP BY ID_Title
   ) AS ti ON ti.ID_Title=t.ID
   SET
     t.cntForSale = ti.cntForSale,
     t.cntInPrint = ti.cntInPrint,
     t.qtyInStock = ti.qtyInStock;</mysql>

<section end=sql />