Instead of this:
SET @SqlQueryFirstName = '@SqlQuery ' + 'firstname = @firstname'
Write this:
SET @SqlQueryFirstName = @sqlquery + 'firstname ='+ @firstname
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/