converting multiple rows into single row

Question

Attaching a image file which will show the exact requirement , Source Table Data which has to be converted into the expected Target Table Data.

Columns are constant i.e. here 16 columns are required in the Target Table.

Kindly let me know what will be the exact logic of converting the data from source table to the target table as required , I have to create a View out of it.

Let me know if any more information is required.

Answer 1

0

Also you can try something along the following lines:

select 
 ID,
 max(case when Code like '%A' then Code else null end) as CodeA,
 max(case when Code like '%A' then Customer else null end) as CustomerA,
 max(case when Code like '%A' then Product else null end) as ProductA,
 max(case when Code like '%A' then Category else null end) as CategoryA,
 max(case when Code like '%B' then Code else null end) as CodeB,
 max(case when Code like '%B' then Customer else null end) as CustomerB,
 max(case when Code like '%B' then Product else null end) as ProductB,
 max(case when Code like '%B' then Category else null end) as CategoryB
from
 SourceTable
group by ID

answered Oct 12 '12 at 04:54 PM

willspurgeon
90 ● 3

Thanks willspurgeon +1 Vote...

Oct 13 '12 at 12:30 PM Kirman1

(comments are locked)

Answer 2

0

I can't be sure what you need based on the information provided, but I think what you're looking for is called a pivot. Here's the second part of an article on how to write a pivot query. Check it out and see if that's what you're looking for.

answered Oct 10 '12 at 10:41 AM

Grant Fritchey ♦♦
62.7k ● 12 ● 20 ● 66

(comments are locked)

converting multiple rows into single row

Follow this question

Related Questions