The attached code loops through a temporary table and runs a complex validation procedure on each row.
I am looking at ways this could be speeded up and am investigating sp_executeSQL as opposed to Exec. I cannot get it to work...the called procedure is still expecting the original parameter names...see the commented line above the sp_executeSQL call.
I have been really struggling with this, and have looked at BOL. If anyone can help me untangle it I'd appreciate it.