May 23, 2011 at 8:50 am
Hello,
I have a table of users and it has come to our attention that many people have used improper names in the first and last name fields. For example some have created what they think is a joint account which we don't really allow. Right now I am writing a script that looks for common joining operators like &, or, and, etc but I think I may be missing many. I am hoping that someone has some better ideas on how to search through this list of users (there are about 200,000). This will be used to create an SSRS report that a CSR will validate and update the names manually so I don't care as much about false positives but don't want to see common 2 word names like "De Leon".
Thanks for the help.
May 23, 2011 at 9:34 am
You are going to have to manually go through this list no matter how advanced your search is. You will have to do something like search where name like <list of values to find> and not like <list of things to exclude>
_______________________________________________________________
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/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply