Character Limitation in sp_executesql

But given that the OP is wanting to use sp_executesql does your answer which uses exec() do the same thing..?

Try this
declare @Sql_1 nvarchar(4000)
declare @Sql_2 nvarchar(4000)
:
:
:
declare @Sql_n nvarchar(4000)

...build you statements split over the @Sql_n vars

exec(@Sql_1 + @Sql_2 + ....+ @Sql_n)


Good Luck

Yes, well then lets see the code, otherwise you not helping enybody but your own ego...

This isn't true. A developer and I have put together multiple 8000 varchar values and executed them with sp_executesql