>I do it with the procedure MonthTable below, but there are 12
>SELECT's per employee, it takes a long time to work.
>Is there any faster solution to do it?

Seems pretty OK to me, but then I don't know very much about SPs. Do you
have an index on (Work_Day, Emp_No)?

I guess you could save a little bit by not calling EOM - after close
examination I have found that it will always be the day before the first of
the following month ;-)

HTH,
Set