Home Forums SQL Server 2005 T-SQL (SS2K5) Transact-sql for changing a telephone number RE: Transact-sql for changing a telephone number
Steve Jones - SSC Editor
SSC Guru
Points: 734498
More actions
March 9, 2009 at 9:59 pm
#956556
Leave it to Jeff to come up with a solution. It's a good one as well.
You want to think pattern, working all rows at once from the pattern perspective, as Jeff has done, and letting the server do the hard work across all rows.