title: INSERT with SELECT returning multiple values throws error "subquery returned more than 1 value"
body: <p>Trying to insert multiple values in a table (as many as ID's from the SELECT result), but the select Id query returns more than 1 value (expected), hence the error.</p>
  <pre><code>INSERT INTO table1 (UserId, Date, ...)
  VALUES
  ((SELECT Id from table2 WHERE ClientId = 26), GETDATE(), ...)
  </code></pre>
  <p>what would be the best approach for this?</p>