title: Can I use SELECT statement inside INSERT values?
body: <p>I tried this:</p>
  
  <pre><code>INSERT  INTO tbl_vaucher
          (
            vaucher_name,
            created_date
          )
  VALUES  (
            ( SELECT TOP 1
                      con_full_name
              FROM    tbl_contact
            ),
            GETDATE()
          )
  </code></pre>
  
  <p>, getting: <code>Subqueries are not allowed in this context. Only scalar expressions are allowed</code>.</p>
  
  <p>I need a solution that would work without functions.</p>