Warning: mysqli_connect(): (HY000/2002): No route to host in /home/skybizgl/public_html/ticket/header-uc.php on line 38

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /home/skybizgl/public_html/ticket/header-uc.php on line 39

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/skybizgl/public_html/ticket/header-uc.php on line 40

Query for switch empty branch code to specific branch code
Knowledgebase
SkyBiz Support Ticket > SkyBiz Support Ticket > Knowledgebase

Search help:


Query for switch empty branch code to specific branch code

Solution

Update stk_pur_requis_dt SET BranchCode = 'xxx' Where BranchCode = '';

Update stk_pur_order_dt SET BranchCode = 'xxx' Where BranchCode = '';

Update stk_grndo_dt SET BranchCode = 'xxx' Where BranchCode = '';

Update stk_sup_inv_dt SET BranchCode = 'xxx' Where BranchCode = '';

 

Update stk_quotation_dt SET BranchCode = 'xxx' Where BranchCode = '';

Update stk_do_dt SET BranchCode = 'xxx' Where BranchCode = '';

Update stk_cus_inv_dt SET BranchCode = 'xxx' Where BranchCode = '';

 

Update stk_inventory_dt SET BranchCode = 'xxx' Where BranchCode = '';

Update stk_inventory2_dt SET BranchCode = 'xxx' Where BranchCode = '';

 
Was this article helpful? yes / no
Related articles Query for switch empty location code to specific location code
update the domain pointing through you WHM
MyFinancial - Query for switch Global Tax To Detail Tax
Article details
Article ID: 363
Category: MySQL Query
Date added: 2018-04-26 10:21:38
Views: 167
Rating (Votes): Article not rated yet (0)

 
« Go back

 
Powered by Help Desk Software HESK, brought to you by SysAid