0 - 1 of 1 tags for nth level
SQL to transpose (row to column) any level (nth level) of data

Hi,
I have a data like below:

Tgt

Src

lvl

L3_Tab1.Col1

L2_Tab1.Col3

0

L3_Tab1.Col2

L2_Tab2.Col2

0

L3_Tab1.Col3

L2_Tab2.Col3

0

L3_Tab1.Col4

L2_Tab2.Col1

0

L2_Tab1.Col3

By Koushik Chandra, 10 Dec 2013 | Tagged: transpose row to column nth level | 5 comments