To convert the row values to the columns
Posted: Wed Jul 09, 2008 7:01 am
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
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