title: SQL Server 2012 - Inserting multiple records from one block of text
body: <p>On SQL server 2012. I have normalized tables that will consist of "notes". Each "note" record can have many notelines tied to it with a foreign key. I'm looking for a SQL statement that will parse a block of text and, for each line within that text, insert a separate record.</p>
  
  <p>I'm guessing some sort of "WHILE loop" for each block of text but can't get my head around how it would work.</p>
  
  <p>To be clear: The end result of this would be to just paste the block of text into the query and execute so that I can get each individual line of it into the note without messing around creating multiple insert statements.</p>