<div>
This works finally: EXEC (@stmt1 + @stmt2 + @stmt3 + @stmt4) .<br />
I was missing something in the previous test.<br />
Thanks for your time
</div>


This works finally: EXEC (@stmt1 + @stmt2 + @stmt3 + @stmt4) .
I was missing something in the previous test.
Thanks for your time

<div>
<div class="content wysiwyg-content">
Hi,<br />
I am busy completing a tracking table change stored procedure. &nbsp;The code is running pretty good with small tables (tables with less fields).<br />
I am facing a problem where the dynamic sql statement &nbsp;size is more than 8000 characters.<br />
I even tried to break it into small pieces like EXEC (@stmt1 + @stmt2 + @ stmt3 + @stmt4), but still can't beat it.<br />
Any input is welcome.<br />
Note: The sql &nbsp;involves the use of UNPIVOT and related fields list comes from a variable, and is formated in a way where It allows conversion of all fields to VARCHAR.
</div>
</div>


Hi,
I am busy completing a tracking table change stored procedure.  The code is running pretty good with small tables (tables with less fields).
I am facing a problem where the dynamic sql statement  size is more than 8000 characters.
I even tried to break it into small pieces like EXEC (@stmt1 + @stmt2 + @ stmt3 + @stmt4), but still can't beat it.
Any input is welcome.
Note: The sql  involves the use of UNPIVOT and related fields list comes from a variable, and is formated in a way where It allows conversion of all fields to VARCHAR.

SQL Server 2008 R2: Execute a Dynamic SQL Statement of more than 10,000 characters

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.