VbzCart/procs/Upd Titles fr Depts - Revision history

Woozle: removed obsolete tag

2015-09-07T01:21:10Z

removed obsolete tag

← Older revision		Revision as of 01:21, 7 September 2015
Line 9:		Line 9:

	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_Depts;		<mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_Depts;
	CREATE PROCEDURE Upd_Titles_fr_Depts()		CREATE PROCEDURE Upd_Titles_fr_Depts()
	REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb)		REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb)
Line 19:		Line 19:
	FROM cat_titles AS t LEFT JOIN _depts AS d ON t.ID_dept=d.ID		FROM cat_titles AS t LEFT JOIN _depts AS d ON t.ID_dept=d.ID
	ORDER BY CatNum;</mysql>		ORDER BY CatNum;</mysql>
	~~<section end=sql />~~

Woozle: /* About */ typo

2010-11-10T15:07:07Z

About: typo

← Older revision		Revision as of 15:07, 10 November 2010
Line 6:		Line 6:
	*** Revised SQL to use "cat_titles" instead of "titles" (obsolete table which has been dropped).		*** Revised SQL to use "cat_titles" instead of "titles" (obsolete table which has been dropped).
	*** Added "DROP PROCEDURE" line for easier maintenance.		*** Added "DROP PROCEDURE" line for easier maintenance.
	*** Created om database (none of the procs had been ported from L48 to Rizzo).		*** Created in database (none of the procs had been ported from L48 to Rizzo).

	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_Depts;		<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_Depts;

Woozle: fixed obsoleteness

2010-11-10T12:24:27Z

fixed obsoleteness

← Older revision		Revision as of 12:24, 10 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''~~Purpose~~''': ~~Fills~~ {{vbzcart\|table\|_titles}}		* '''Input''': {{vbzcart\|table\|cat_titles}}, {{vbzcart\|table\|_depts}}
			* '''Output''': {{vbzcart\|table\|_titles}}
			* '''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 om database (none of the procs had been ported from L48 to Rizzo).
	==SQL==		==SQL==
	<section begin=sql /><mysql> CREATE PROCEDURE Upd_Titles_fr_Depts()		<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_Depts;
	REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb)		CREATE PROCEDURE Upd_Titles_fr_Depts()
	SELECT		REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb)
	t.ID,		SELECT
	d.ID_Supp,		t.ID,
	UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,		d.ID_Supp,
	LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb		UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,
	FROM ~~titles~~ AS t LEFT JOIN _depts AS d ON t.ID_dept=d.ID		LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb
	ORDER BY CatNum;</mysql>		FROM cat_titles AS t LEFT JOIN _depts AS d ON t.ID_dept=d.ID
			ORDER BY CatNum;</mysql>
	<section end=sql />		<section end=sql />

Woozle: New page: ==About== * '''Purpose''': Fills {{vbzcart|table|_titles}} ==SQL==
CREATE PROCEDURE Upd_Titles_fr_Depts() REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb) ...

2009-03-08T19:38:50Z

New page: ==About== * '''Purpose''': Fills {{vbzcart|table|_titles}} ==SQL== <section begin=sql /><mysql> CREATE PROCEDURE Upd_Titles_fr_Depts() REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb) ...

New page

==About==
* '''Purpose''': Fills {{vbzcart|table|_titles}}
==SQL==
<section begin=sql /><mysql> 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 titles AS t LEFT JOIN _depts AS d ON t.ID_dept=d.ID
ORDER BY CatNum;</mysql>
<section end=sql />

VbzCart/procs/Upd Titles fr Depts - Revision history

Woozle: removed obsolete tag

Woozle: /* About */ typo

Woozle: fixed obsoleteness

Woozle: New page: ==About== * '''Purpose''': Fills {{vbzcart|table|_titles}} ==SQL== CREATE PROCEDURE Upd_Titles_fr_Depts() REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb) ...

Woozle: New page: ==About== * '''Purpose''': Fills {{vbzcart|table|_titles}} ==SQL==
CREATE PROCEDURE Upd_Titles_fr_Depts() REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb) ...