HQ Query needed for change in department/category

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello!

Can anyone help with a query that would seperate departments/category?

Right now we have Jewelry/Yellow Gold and Department and bunch of categories no longer needed. I would want to assign the new department "Jewelry" and new category "Yellow Gold" to all the items in the original category.

Thanks in advance!
Diana

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: HQ Query needed for change in department/category

update item set departmentid = (replace this with id you need) from item where departmentid = (old id), updatedtime=getdate()

no () with your id's and use categoryid as well for the cat's

use at your own risk, backup first and call an expert...

DISCLAIMER: I refute all liabilities on this snipplet. ;)