SQL Solution: Conversion failed when converting the nvarchar value 'SELECT' to data type int.

Message: Conversion failed when converting the nvarchar value 'SELECT' 
to data type int.

Solution: CAST(@PARAMETER AS NVARCHAR(10))