I would like to echo Nakul's sentiment.

Thanks to everyone involved with SSC (posters and staff),

Its a fabulous resource and ive learnt so much by reading and contributing to it.

It sounds to me that you are attempting to solve the 'catch-all' query problem.

IMO , the best way to handle those are by using Dynamic Sql.

Gail Shaw has documented that...

IMO , its always worth starting with tuning your TSQL code ( including indexing strategies and statistics).

If you have poorly performing SQL , you will have poorly performing...

Scalabilty is ALWAYS something to consider.

Parthi's solution , though perfectly adequate for three rows, will die when using one million rows.

Overkill ? Perhaps ? But smaller problems are practice for...

Seriously , really ??!?!?

http://www.sqlservercentral.com/Forums/Topic999726-149-1.aspx

This one is bang on topic, "Are the posted questions getting worse".

Tried to think of a sane , and not to scathing reply , its been...

1) "Best" is a tricky one , it depends. BUT to force through this query ,set it to 1GB. You should be able to change that on...

Use could use a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

or a tally table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-numbers-table.html

Is it being called by another SP ?

take a look at the INFORMATION_SCHEMA.ROUTINES view.

If it is sqlagent have a look at the sysJobSteps table in msdb

http://msdn.microsoft.com/en-us/library/ms187387.aspx

🙂

No worries , but i did make an error in my update statement , didnt...

Its sounds as if the bottle neck is writing to the logfile.

What are your autogrowth settings ? If this is to small it will be a overhead having to...

Have you confirmed that the update is not being blocked ?

I would imagine both of those queries will force a table scan anyway.

Any triggers / referential integrity to be checked.

If...

Thanks for the repro script , it obviously is a bug.

I suggest...

What happens , if you cut the query down to 5,10 , 15 or 20 tables ?

Do you get the same error ?

Can you post a full reproduction script ?

Also...

Im assuming that the sp is being called by a .net application which a developer has some form of control over.

In which case the app shouldnt concatenate the ids...