Yeap. You are right. There are two options

Hoo,

tmpCDR_Hold_Table is a temporary storage for any data that EXECUTE sp_executesql @resQuery returns. @resQuery is the one that might retun invalid table name, so it has to be where it is...

Thank You. Yes you are right I just newbie. I should have checked sproc myslef not on online books.

I found the answer myself. Here is to everyone to share:

INSERT INTO tmpCDR_Hold_Table EXECUTE sp_executesql @resQuery SELECT @errCode = @@Error, @rCounter = @@Rowcount

You mean:

INSERT INTO tmpCDR_Hold_Table EXECUTE sp_executesql @resQuery, @@Rowcount, @@error

sp_executesql only takes sp_executesql [@stmt =] stmt

However this works: INSERT INTO tmpCDR_Hold_Table EXECUTE sp_executesql @resQuery SET @rCounter = @@Rowcount SET @errCode =...

David,

INSERT INTO tmpCDR_Hold_Table Exec( @resQuery) SET @rCounter = @@Rowcount

It worked. Thanks a lot. That IF statement was messing around, I didn't know that it affects.

Thanks for reply.

Thats the first time I see wildcard used this way. Very interesting.

Here is the query that I have:

SET @lrgtblNAme = 'mdCallAttempt' + @year + @month

SET @resQuery =...