How do I return data from a SQL String_split function into my table
<p>Using the newest SQL update and String Split Function how do I insert the split data back into my table?</p>

<pre><code>select be.*, SS.value
from b2bemployee be
outer apply string_split(firstname, ' ') AS SS
where id=2319
</code></pre>

<p>Using that I split my FirstName column into two values and the data is returned on two separate rows. I am trying to insert this data back into my table as <code>updatedfirstname</code> (before the space) and <code>updatedlastname</code> (after the space)</p>