title: TSQL insert into table with bulkcolumn -- needing two bulkcolumn inserts into same row
body: <p><strong>TSQL insert into table with bulkcolumn -- needing two bulkcolumn inserts into same row</strong></p>
  
  <p>I need to run a query with two bulkcolumn inserts into the same row.</p>
  
  <p>I am trying:</p>
  
  <p>However, I get the error:   Invalid object name 'BulkColumn' 
  Is this just a syntax problem, or is this a more fundamental rule (such as one can only insert one bulkcolumn per statement)?</p>
  
  <p>Example:
  in the SSMS edit-window.</p>
  
  <pre><code>INSERT INTO [table1] ([id1], [bulk1],[bulk2] 
  SELECT '123',
   BulkColumn 
  FROM Openrowset( Bulk 'C:\bulkDir1\a1.jpg', Single_Blob) as a1,
  BulkColumn 
  FROM Openrowset( Bulk 'C:\bulkDir2\b1.jpg', Single_Blob) as a2
  </code></pre>
  
  <p>It says (in the 'squiggly error' in the SSMS edit-window.):<br>
  Invalid object name 'BulkColumn'</p>