|are hours always same for given job desc|
across case numbers and employee?
f/e: if jobdesc is "foreman night shift", hours always 8.
global for all cases.
if so, that eliminates one vector.
so then call this h.
select job desc.
[hours now assigned to "h"]
that sets hours. then need a table with employee vs case#
for payrates on different case no.s.
set emloyee id as vector one (row#), set all pay cases as vector two (col head), and each cell should be employees payrate for that case#. locate employee in rows, case# in colheads, then mult h times [row,col] cell. i apologize in advance for any misunderstanding, i am not database proficient, so no offense if foregoing is painfully obvious to you.
just trying to help. i have not worked with sql.