Mad-Dog (11/1/2012)
Hi,is there any quick way to find the problem in this query?
the error is:string or binary data would be truncated
the query:
exec sp_executesql
Why are you using dynamic sql for this?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden