Hi All,
i want to change the row values to the values of difrent columns
my source is like
ID Type
1 Clerk
1 Accountant
1 Manger
my taget should be the like this
ID TYPE_Clerk Type_Accountent Type_Manger Type_Gm
1 Clerk Accountant Manger NULL
if any one have any idea please reply back that would be the great
Thanks
To convert the row values to the columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 70
- Joined: Thu Nov 09, 2006 2:14 am