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:12 pm

  #3646956

   

  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: 99130

  More actions

  May 24, 2019 at 1:21 pm

  #3646959

  Cross post of https://www.sqlservercentral.com/forums/topic/how-to-map-the-table-data-while-inserting-into-another-table-in-sql and https://www.sqlservercentral.com/forums/topic/how-to-map-the-table-data-while-inserting-into-another-table-in-sql-2. I suggest replying on the OP's original post.

  Thom~

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