SQL Server INSERT INTO SELECT

1) Insert all rows from another table example

2) Insert some rows from another table example

3) Insert the top `N` of rows

4) Insert the top percent of rows