I have a requirement to load data into database column based on the value coming from input field.
Here we have more than 1000 columns like this Dept_10_Sal, Dept_20_Sal........Dept_1000_Sal.Eg:
Input:
EmpNo, DeptNo, Sal
1234, 10,1000
1234,20,2000
1234,30, 3000
1234,40,4000
2345,10,100
2345,20,200
2345,30,300
Output:
Emp No, Dept_10_Sal,Dept_20_Sal,Dept_30_Sal,Dept_40_Sal
1234, 1000, 2000,3000,4000
2345,100, 200, 300,0
Can any body advise on this how do we approach this result.
Thanks
Prasad