I have a Table
SL, R_ID, Name, AMT1, AMT2, AMT3, Pos
1 5 ggg 10 60 22 Left
2 5 hhh 44 88 47 Right
I want Output Like this
LSL, LID, LName, LAMT1, LAMT2, LAMT3, LPos SL, RID, RName, RAMT1, RAMT2, RAMT3, RPos
1 5 ggg 10 60 22 Left 2 5 hhh 44 88 47 Right
What I have tried:
SELECT SL, [LSL], [LSL_HEAD], [LAMT], [LCURR], [LPRE], [RSL], [RSL_HEAD], [RAMT], [RCURR], [RPRE]
FROM
(select SL, R_ID, SL_HEAD, AMT, CURR, PRE, L_SLIDE from FinalAccountDetails f) as st
PIVOT
(
max(R_ID)
FOR
[L_SLIDE]
IN ([LSL], [LSL_HEAD], [LAMT], [LCURR], [LPRE], [RSL], [RSL_HEAD], [RAMT], [RCURR], [RPRE])
) AS pvt