will see your response 2moro... off to home..

while searching this issue over the internet I have come across an assertion as, On concatenating nvarchar + navarchar, it will truncate at 4000 characters.

I have check this limitation on...

@tSprocSQL1 is initialized as a blank string.

DECLARE @tSprocSQL1 nvarchar(max)

SET @tSprocSQL1 = N' '

It seems the problematic query truncates data above 4000 bytes.

it does not giving error, but truncating the data.

what is the limitation of concatenation which is causing below issue?

Any help?

This query does not work:

SET @tSprocSQL1 = @tMidSQL1+@tMidSQL2+@tMidSQL3+@tMidSQL4+@tMidSQL5+@tMidSQL6+@tMidSQL7+@tMidSQL8+@tMidSQL9+@tMidSQL10+@tEndSproc+ CHAR(13);

Whereas query works:

SET @tSprocSQL1 = @tMidSQL1+@tMidSQL2+@tMidSQL3+@tMidSQL4+@tMidSQL5+@tMidSQL6+@tMidSQL7+@tMidSQL8

SET @tSprocSQL1 = @tSprocSQL1+@tMidSQL9+@tMidSQL10+@tEndSproc+ CHAR(13);

___________________________________________________________

@tSprocSQL1 -...