insert statement

• adaa_2007

  Newbie

  Points: 9

  More actions

  January 4, 2010 at 1:42 am

  #141398

  insert statement with join or with multiple tables

  i hav 3 tables with no unique column. n i want to insert tjhe record in 3 tables in one insert query any suggestion?

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  January 4, 2010 at 1:51 am

  #1098303

  We're happy to help, but need example data and a look at what you've tried already.

  For information on how to post sufficient details:http://www.sqlservercentral.com/articles/Best+Practices/61537/

  BrainDonor

  Steve Hall
  Linkedin
  Blog Site

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  January 4, 2010 at 2:27 am

  #1098310

  adaa_2007 (1/4/2010)

  ---

  insert statement with join or with multiple tables

  i hav 3 tables with no unique column. n i want to insert tjhe record in 3 tables in one insert query any suggestion?

  You can't (the OUTPUT clause won't help you in this context). You can only INSERT into one table with one insert query.

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden