VbzCart/procs/Upd Titles fr Depts

About

 * Input: ,
 * Output:
 * History:
 * 2010-11-10
 * Revised SQL to use "cat_titles" instead of "titles" (obsolete table which has been dropped).
 * Added "DROP PROCEDURE" line for easier maintenance.
 * Created in database (none of the procs had been ported from L48 to Rizzo).

SQL
DROP PROCEDURE IF EXISTS Upd_Titles_fr_Depts; CREATE PROCEDURE Upd_Titles_fr_Depts REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb) SELECT t.ID, d.ID_Supp, UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum, LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb FROM cat_titles AS t LEFT JOIN _depts AS d ON t.ID_dept=d.ID ORDER BY CatNum;