Learner44 (7/22/2013)
Hi Sean this is WONDERFUL solution, i believe in my current situation.
Just wondering, once account number chages with update, it makes permantaly chages.
if admin want to refer back to the original account number how he can go for it??
I guess before we make an final update , introduce new column into table and populate it with actual account number .
and then apply the operation of masking them!!!!
Am I right?
thanks.
The intention of my code was to be used in a dev environment which I believe is the whole point of this exercise? If the data changes, just refresh from live whenever you need to do and rerun the tweaking code. Dev data will never be totally in synch with live data so this isn't something you should need to worry about realtime anyway.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/