My guess, the same.  Test it yourself and see, that is the best way to answer this question.

Not overly happy with the new site.  Even looks like some of the forum posted entered recently have gone missing.

Simpliest way, define two variables (@errcode and @rowcnt for instance) and capture the values of @@ERROR and @@ROWCOUNT immediately following each statement using SELECT @errcode = @@ERROR, @rowcnt = @@ROWCOUNT,...

Wasn't broken earlier today.  That is how I found that site emails (PM messages) are missing.

I get the notification emails.  I was talking about the PM emails on the site.

If you go up to your name in the navigation bar, you can get to your profile.  When I did that, what I found was that the site emails (PM...

Have you looked at the execution plan for the query?

You may want something like this:

/*
ID: 233 ID_List: 453453

ID: 543 ID_List 345345, 56756

ID 654 ID_List 43235, 78978, 7893745
*/

DECLARE @TestData table (ID int, IDList varchar(8000));
INSERT INTO @TestData
(
 ...

Have you posted the full code you are working with or are you simplifying what  you are working with?  If the latter, you are losing much in the translation.  It...

Without seeing what you are doing it is really hard to answer your question.

Considering how much dynamic SQL I write where I work, this was a very easy question.  I use sp_executesql extensively in my code where I need to run dynamic SQL.