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

Question

Viewing 3 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: 99143 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: 247183 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?

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