Skip to Content
0
Former Member
Nov 30, 2011 at 01:02 PM

from rows to coloum genenarion

37 Views

hiiie,

no empno name

11 91 Man

11 92 DR

11 93 PAT

13 94 MANU

13 95 DRA

13 96 PAT

suppose i have a input like the above and i want a op like

no emp1 emp 2 emp3

11 91 92 93

13 94 95 96

using pivot i tried but not getting

thnx