Insert multiple rows using a single SQL INSERT statement

How to insert multiple rows using a single SQL INSERT statement.

INSERT INTO MyTable ( Column1, Column2 ) VALUES
( Value1, Value2 ), ( Value1, Value2 )

Example of updating SQL table with join's and subselect