Could someone provide a SQL Query to copy or move data in the Sub Description #3 field on the General Tab to the Reorder # field on the Suppliers tab of the item propertis window?
A customer has been using the Sub Description #3 field to track reorder numbers, rather than entering them on the suppliers tab in the reorder # field.
I would really appreciate it.
Thank You
*This post is locked for comments
UPDATE SL
SET SL.[ReorderNumber] = I.[SubDescription3]
FROM [SupplierList] SL
JOIN [Item] I
ON I.[SupplierID] = SL.[SupplierID]
AND I.[ID] = SL.[ItemID]
WHERE SL.[ReorderNumber] <> I.[SubDescription3]
AND LEN(I.[SubDescription3]) > 0
This is provided as is and I'm not responsible for any data problems etc etc - take a back-up first!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,316 Most Valuable Professional
nmaenpaa 101,156