OUTPUT clause in UPDATE statements

Sometimes you need to update data in a table and then update data in another table but based on a filter condition found from the first table. Use the OUTPUT clause to obtain data from the UPDATEd row(s) in order to use them further. Also this is a "thread-safe" way to obtain data.