How to map the table data while inserting into another table in sql

• nagaraj

  SSC Enthusiast

  Points: 117

  More actions

  May 24, 2019 at 1:11 pm

  #3646954

  table1

  id   value

  2    20

  3    30

  4    40

  5    50

  6    60

  7    null

  the above table has to be inserted into another table2 with following fashion

  i,e: it has to insert the value corresponding to 2 into col1 when id =2 ,col2 when id=3  and so on.  note: insert empty when null is the value

   

  table2

  col1      col2    col3    col4    col5     col6

  20          30     40      50         60      empty

   

• Thom A

  SSC Guru

  Points: 99143

  More actions

  May 24, 2019 at 1:22 pm

  #3646960

  What have you tried so far? Have you had a look at PIVOT, or (what many prefer), using a Cross Tab?

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  May 24, 2019 at 7:59 pm

  #3647109

  What would you insert if there are multiple source rows with the same Id? For example

  id   value

  2    20

  2    30

  Would this require two inserts of 20 and 30, or a single insert of 50 (SUM), 25 (AVG), 20 (MIN) ... or some other aggregate?

  ---

• nagaraj

  SSC Enthusiast

  Points: 117

  More actions

  May 25, 2019 at 12:29 am

  #3647165

  There multipl wont be any scenario like multiple source rows with the same Id in my case