Customers, employees, etc. come and go. They get entered multiple times in inconsistent formats in databases.
This simple script finds the duplicates across multiple formats and is easily modified as needed. It's so easy, my grandmother could do it. Oops! No offense Grandma.
For very large databases, create and join two temp tables indexed on the namedatetring value.
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.