Column Name and Column value needs to be inserted in another tableHi,
I have table which contains N no of columns. I have another table which contains ID(Identity column), DataColumnName,DataColumnValue. I need to insert all the column name and corresponding value in the second table.
EmpId EmployeeName EmployeeSalary
1000 David 10000
1001 John 15000
ID EmpID DataColumnName DataColumnValue
1 1000 EmployeeName David
2 1000 EmployeeSalary 10000
3 1001 EmployeeName John
4 1001 EmployeeSalary 15000
Thanks in Adavance.