I have a multi table database that has a bunch of phone number fields in the various tables. I need a stored procedure that i can execute on the DB to scan all tables for the phone number fields and then format the phone numbers to one of two formats depending on the presence of an extension.
The format should be either:
(###) ###-#### ext. ##### the extension can be 1-5 digits
Please not teh singe space between the ) and first digit in the prefix as well as 2 spaces on each side of extension AND the period after "ext"
Existing phone numbers in these fields are all North American but may be dirty or incorrect for example:
(000) 768-2345 or (002) 234-4560
impossible or bad phone number. In these cases keep leading zero's..we will make user correct at the presentation level.
I can supply table names and phone number fields if you would like.
8 tables and about 15 or 16 phone number fields total.
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):
. Check for publisher's certificate revocation
. Check for server ce…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server. I hate doing this. There's so many different tables and data types. Some column data needs quoted and some doesn't. What …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…