Group by and order by were already in my snippets and I'm pretty sure I didn't put them there. Nice examples, though.

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...

DECLARE@array varchar(max)

DECLARE...

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...

Martin Sujkowski (3/31/2009)

---

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...