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