245
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!
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
