That's because you have declared your statement as varchar. sp_executesql only accepts nvarchar.

Your

DECLARE @SqlQuery varchar(max)

should be

DECLARE @SqlQuery Nvarchar(max)

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]