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]