Sql updating a table from the same table
The OUTPUT clause is not supported in any DML statements that target remote tables or views.
For more information, see OUTPUT Clause (Transact-SQL).
TOP ( ) Specifies one or more table hints that are allowed for a target table. If 'N' is not specified, SQL Server converts the string to the code page that corresponds to the default collation of the database or column.Any characters not found in this code page are lost.