SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL

Five small carts each carrying one crate, beside one cart carrying all five together.

SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL

Insert multiple records with one INSERT statement by combining SELECT and UNION ALL, instead of a separate INSERT for every row. SQL Server 2008 has a newer way.