Alpha100 Commented 12 Months ago through
Puzzles
Thank you for let me see your solution it works great.
In mine I couldn't get the format right
select E.EmpID,E.EmpName,
Pay.WeekStart,
Pay.WeekEnd,
EV.EarningCode,
convert(decimal(10,2),sum(datediff(n,EV.StartTime,EV.EndTime)/60.0)) as [hours]