web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / HQ Query needed for ch...
Microsoft Dynamics RMS (Archived)

HQ Query needed for change in department/category

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    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. ;)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans