Stored Procedure to Copy from 1 table to another

• Darryl Wilson

  Mr or Mrs. 500

  Points: 526

  More actions

  January 6, 2005 at 4:57 am

  #66382

  I have in one table the following:

  TABLE A

  SessionID, QuizID, QuestionID, AnswerID, Answer

  And I want an SP to transfer from this table to Table B with the following structure:

  TABLE B

  UniqueID (which I get somewhere else),QuestionID, ColumnID (AnswerID), Answer

  So there are 3 columns the same, so i want to transfer where the sessionID is X into

   

  Any help would be appreciated

  Darryl Wilson
  darrylw99@hotmail.com

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 6, 2005 at 5:12 am

  #536141

  INSERT INTO...SELECT... should help

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• David Burrows

  SSC Guru

  Points: 65138

  More actions

  January 7, 2005 at 3:50 am

  #536352

  CREATE PROCEDURE usp_copy_session

      @SessionID int,

      @UniqueID int

  AS

  INSERT INTO

  (UniqueID, QuestionID, ColumnID, Answer)

  SELECT @UniqueID, QuestionID, AnswerID, Answer

  FROM

  WHERE SessionID = @SessionID

  Far away is close at hand in the images of elsewhere.
  Anon.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 7, 2005 at 4:25 am

  #536357

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]