Hi,

Instead of writing SET @SqlQueryFirstName = '@SqlQuery ' + 'firstname = @firstname' this use below code.

SET @SqlQueryFirstName = @sqlquery + 'firstname = @firstname'

i.e. remove single quotes from @sqlquery.