Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / query help please
Microsoft Dynamics RMS (Archived)

query help please

(0) ShareShare
ReportReport
Posted on by Craig Wood 785
I need to add the words "dog food" to the extended description of every item in my "Dog Food" Department. If someone could please help with a SQL query so I wouldn't have to go into each item individually I sure would appreciate it. I just recently purchased a Star TSP100 Future print receipt printer, and it has the capability to print coupons at the end of the receipt depending on key words you specify that show up on the receipt. Using the extended description field to add keywords for the software to pick up on is the best and easiest way I could think of achieving this since not all dog foods have both dog and food in the description. Thanks in advance. Craig

*This post is locked for comments

  • Craig Wood Profile Picture
    Craig Wood 785 on at
    Re: Re: query help please
    Thanks for the reply Convoluted. I knew I would be able to count on you if no one else responded. It's also a good example of how much faster the response time is on the NG versus this forum. It's just a much better setup since you can get all the posts right next to your email, it's much more likely the people you need to see your question will actually see it in a timely manner. With the forum there's an extra step involved. That doesn't seem like much, but in our busy daily lives it can make all the difference in whether or not the help comes when needed. Craig
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: query help please

    Hi Craig - saw you got a solution on the Corn Flakes Newsgroup ("The Original and Best").

    Good example of how solutions are quick to come when the end user knows and communicates what it is they are trying to accomplish, or what business issue they are looking to solve.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans