We've recently discovered that a large number of the addresses on our Institutional constituents were entered weirdly, with the street address in Street Address 1 and the organizational name in Street Address 2 (see pic for example). So when we create addresses from these entries, we end up with:
John Doe
1 Main St
Business Name
City, State Zip
If I isolate into a list all of the records that need to be updated, is there a SQL process that could automatically switch Street Addresses 1 & 2 for all of those records? Or are we stuck updating these one by one?
Thanks, from a grateful SQL beginner!
This is something you could do using SQL, Of course, do the development work in TEST first before running it in PROD. Maybe someone here has something like this written already?
You'll want to be careful to ensure that the entries are consistent though - you wouldn't want to switch ones that are correct. This isn't something that someone unfamiliar with SQL should do though, as it is going to take multiple steps.
I think I'd start with a list. Scan the list to see how many of entries are correct and, like you said, note them. The correct ones could be used in an exclusion table so that you don't update something that is correct. Then you could create a table with the addresses and business names for each constituent ID and simply overwrite what exists with what is in the temp table.
If you're not super handy with SQL, Extended Services could probably knock this out pretty quickly.
Hope this helps..