how to write coding to convert data from one table to another

Hi all

I want to convert data from one table to another by using cursor

My case is

I have table App_Profile and have data's in it i want to convert datas corresponding to particular id to another table emp_Profile.There may be more than one rows for each id...whatever be the number i want whole data corresponmding to that id to another table ..

Can anybody suggest idea i want to write code in backend side

Thanks in advance

[Resolved]