How to insert data into the second table horizontally. Kindly assist
from
ID EMPID HEADID Compcode Compname Amount datetim
44 120 3 3 Basic 300 17-Aug-19
45 120 3 2 Attendance 250 17-Aug-19
46 120 3 3 Health Insurance 100 17-Aug-19
47 120 3 8 Loan 100 17-Aug-19
48 120 3 9 Advance Salary 50 17-Aug-19
to
Date EMPID Basic Attendance Health Advance Salary Loan
17-Aug-19 120 300 100 250 50 100
for further manipulation.
Thank you.
from
ID EMPID HEADID Compcode Compname Amount datetim
44 120 3 3 Basic 300 17-Aug-19
45 120 3 2 Attendance 250 17-Aug-19
46 120 3 3 Health Insurance 100 17-Aug-19
47 120 3 8 Loan 100 17-Aug-19
48 120 3 9 Advance Salary 50 17-Aug-19
to
Date EMPID Basic Attendance Health Advance Salary Loan
17-Aug-19 120 300 100 250 50 100
for further manipulation.
Thank you.