SQL help needed
Posted on 2014-10-10
I have a rather complicated stored proc that does take a few seconds to run, it loads customer data from several sources into a temp table, and returns that table.
What I need now is a way to mark customers that have the same name but different ID's so the users can perform additional checks to make sure they have the right one.
I can't think of an efficient way to do this. Maybe a count on name in the temp table?