Dear Brother's I have Table in which records are in following manners..
EmployeeID -- StructureID -- StructureAmount -- DeductionID -- DeductionAmount
01 01 13500 01 70.0
01 02 1500 02 0.0
01 03 1230 03 500
02 01 14500 01 0.0
02 02 1400 02 405
02 03 1100 03 0.0
. . . . .
and So on.. Where StructureID 01 = Basic Salary, 02 Medical, 03 Connvence and DeductionID 01 = IncomeTax, 02 = Leave Fine, 03 = Loan,
Now I want to write a stored procedure which show Data like this....
EmployeeID -- Basic Salary -- Medical -- Connvence -- IncomeTax -- LeaveFine -- Loan -- TotalSalary
01 13500 1500 1230 70.0 0.0 500 15660
02 14500 1400 1100 0.0 405 0.0 16595
. . . . . . . .
and so on,
If any Brother have idea how to slove this qurey then please share it.. I need this very much....