This helps the original query handle the case of a single value passed in? Not sure if it's the most elegant solution since I'm checking charindex many times, but...
As someone else mentioned, using IDENT_CURRENT('SystemRepairStage') is bad. It might not be related to your current problem. It's possible depending on how your code is written and how...
This post has gone off track because we were discussing where the problem might lie. I believe it lies with sql server while others believe it may be...
It really does sound like a problem with the application, not the database or the procedure. Profiler will let you know if this is happening. Especially if you're...