> (select max(h.totalhrs), InvoiceDate from hrsworked h …
>

Not sure what your first query was about, but some table structures
would help a lot more. Read up on group by (and possibly having if you
want to limit based on the dates with at least a certain number of
total hours.

select h.InvoiceDate, max(h.TotalHrs)
from hrsWorked h
group by h.InvoiceDate

Adam