I imported the PLUs from a grocery store into RMS. Is there a way to append the 0 in front of all ItemLookupCode that have a length of 10 AND do not start with zero?
After I do that, how do I make sure HQ sync's those items with SO?
David
I imported the PLUs from a grocery store into RMS. Is there a way to append the 0 in front of all ItemLookupCode that have a length of 10 AND do not start with zero?
After I do that, how do I make sure HQ sync's those items with SO?
David
ALWAYS take a backup of your database BEFORE running any update, insert or delete query!
update item with (rowlock) set itemlookupcode = '0' + itemlookupcode, LastUpdated = GetDate() where len(itemlookupcode) AND itemlookupcode NOT LIKE '0%'
Then run a 250 worksheet for all recently changed items...
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.