title: T-SQL Update table columns using function
body: <p>I have the following table:</p>
  
  <pre><code>RecordID 
  Name
  Col1
  Col2
  ....
  ColN
  </code></pre>
  
  <p>The <code>RecordID</code> is <code>BIGINT  PRIMARY KEY CLUSTERED IDENTITY(1,1)</code> and <code>RecordID</code> and <code>Name</code> are initialized. The other columns are NULLs.</p>
  
  <p>I have a function which returns information about the other columns by <code>Name</code>.</p>
  
  <p>To initialized my table I use the following algorithm:</p>
  
  <ol>
  <li>Create a LOOP</li>
  <li>Get a row, select its <code>Name</code> value</li>
  <li>Execute the function using the selected name, and store its result
  in temp  variables</li>
  <li>Insert the temp variables in the table</li>
  <li>Move to the next record</li>
  </ol>
  
  <p>Is there a way to do this without looping?</p>