Bulk insert of rows with sql server

sql server
I'm not sure how many total weeks of my life I've spent on data import. Many. Maybe Hundreds. Also, every new project needs test data and usually we'll write INSERT INTO blah blah full scripts again and again. Here's a way to slightly reduce the amount of text that needs to be written/sent to the server AND make your scripts cleaner. Available Sql Server 2008 and up.

CROSS JOIN with filter equals INNER JOIN on Sql Server

linq to sql    sql server
Cross join with filter equals inner join with filter. A little experiment to test what Sql Server with it's query optimisation and with how linq does it's magic.