VbzCart/procs/update cat items fr qryCtg build

About

 * Status: Apparently disused.
 * Requires: ,
 * History:
 * 2010-11-09 Found this procedure in the database, but could not identify where it was being used. As there was no documentation of it either, I am documenting it here and removing it from the database.

SQL
DROP PROCEDURE IF EXISTS `update_cat_items_fr_qryCtg_build`; CREATE PROCEDURE `update_cat_items_fr_qryCtg_build` UPDATE qryCtg_build AS r LEFT JOIN cat_items AS i ON r.ID_Item=i.ID SET i.CatNum = r.CatNum, i.isForSale = r.isForSale, i.isInPrint = r.isInPrint, i.isCloseOut = r.isCloseOut, i.isPulled = FALSE, i.isDumped = FALSE, i.ID_ItTyp = r.ID_ItTyp, i.ID_ItOpt = r.ID_ItOpt, i.ItOpt_Descr = IFNULL(r.ItOpt_Descr,i.ItOpt_Descr), i.ItOpt_Sort = r.ItOpt_Sort, i.ID_ShipCost = r.ID_ShipCost, i.PriceBuy = r.PriceBuy, i.PriceSell = r.PriceSell, i.PriceList = r.PriceList, i.GrpCode = r.GrpCode, i.GrpDescr = r.GrpDescr, i.GrpSort = r.GrpSort, i.CatSfx = r.CatSfx WHERE r.ID_Item IS NOT NULL;