updating date based on search results
What's the best way to do this? I need to search an invoice table. For a specific company name, I need to update all invoice dates to match their shipping dates. In other words, I need to search for a company name, and for each match update the invoice date to be the shipping date.