title: SQL Get id value and insert into another column
body: <p>I am attempting to create an sql statement that will insert an inital record, retrieve the new id (a autonumber primary key) and insert that into another column in the table to serve as a defualt value.</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>INSERT INTO users (first_name, last_name, email, password, shot, year, campus, subject,
  
   qual_level, job_title, blurb, presentions, offers, moderated, version_current,
  
   version_replace, salt, loggable) VALUES (@sfirst_name, @slast_name, @semail, @spassword,
  
   @sshot, @syear, @scampus, @ssubject, @squal_level, @sjob_title, @sblurb, @spresentions, 
  
  @soffers, @smoderated, @scurrent_version, @sversion_replace, @ssalt, 1) SELECT 
  
  SCOPE_IDENTITY() as NewId UPDATE users (version_replace) VALUES (NewId) WHERE id = NewId
  </code></pre>
  
  <p>This isn't working as is and I could use a hand to correct the syntex</p>