News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Need a SQL QUERY

Microsoft Dynamics RMS (Archived)

Need a SQL QUERY

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi,

I need queries for automatically check off all items which are checked off in options for available on webiste to be off.

We are recreating a website on shopify and we had all items checked on available on site before; now we have chose to enter selective items ; so we want to turn all off and then manually select items to synchronise the web items that we want.

So if you can help us write the query that will turn all off; and then 2nd query to turn all on which has qty on hand more than 6.

One more thing is how to export hq database to excel and import back to databse after changes?

Thanks,

Raj

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Need a SQL QUERY

Thank you so much, it worked. I appreciate it.
Verified answer

eliud mugo 1,440 on at

Like (0)

Report

RE: Need a SQL QUERY

1.To turn off use below query.

update item set webitem='0'

2.To turn on where on hand greater than 6 use below query.

update Item set webitem='1' where Quantity > '6'

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans