RMS SQL items table update

(0) Share

Report

Posted on by Community Member Microsoft Employee

i am trying to find where "Item > Special > Notes" field exists in SQL tables. i looked under dbo.item and did not see it there..

what i am trying to do is moves all the text in "Sub Description 2" over to notes field.

thank you in advance.

*This post is locked for comments

All responses (3)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: RMS SQL items table update

Thank you this is exactly what i was looking for. i will try this in a test database.

Thank you.
Verified answer

Antonijo Todorovik 4,025 on at

Like (1)

Report

RE: RMS SQL items table update

Hi bart101.

Notes field is in the Item table (standard Items, not Matrix header has it's own Notes field in the ItemClass table), it's calles NOTES and it's NTEXT type (SQL) and it allows NULL value.

If You want to move all the SubDescriotion2 values into Notes filed, the query You need is this next:

UPDATE [dbo].[Item]

SET [Notes] = [SubDescription2]

WHERE [SubDescription2] <> ''

It will only update the Notes field for the Items where SubDescription2 is different then nothing. Also, this will not "clean" all the SubDescription2 field values. If you want to do that also, the query should be:

UPDATE [dbo].[Item]

SET [SubDescription2] = ''

Please :

- do this first in testing environment

- make a backup of the RMS database before doing this

- stop RMS HQ Server and RMS HQ Client while doing this

- If You are working in a RMS HQ environment, do this at RMS HQ and send an item update worksheet for the stores

Hope this helps, BR. A.
Suggested answer

Community Member Microsoft Employee on at

Like (2)

Report

RE: RMS SQL items table update

The Notes field from RMS Manager is dbo.Item.Notes

the subdescription2 field is dbo.Item.SubDescription2

Notes is a ntext field (basically no limit)

subdescription2 is nvarchar(30) which means it is limited only 30 characters.