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

Question

Post reply

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
May 28, 2019 at 4:56 pm

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99130 More actions · Answer 1

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: 246960 More actions · Answer 2

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?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

nagaraj SSC Enthusiast Points: 117 More actions · Answer 3

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