AnsweredAssumed Answered

Break PRTIMEENTRY Into Daily Totals

Question asked by Shane.Steeves on Aug 21, 2013
Latest reply on Aug 23, 2013 by Dave
Hi. I've been working on this for over a week now, and desperately seeking some assistance.

So far I've come up with the following query, which seems to bring back all our Indirect Time from the PRTIMEENTRY table, by week. So one record would return 40 hours, if that person had 5 vacation days in the current week.

How can I break this down into daily detail? So that I could query an exact month, from the 1st to the 31st, without worrying that the 1st may fall mid week on an actual time sheet. I found a few related posts, but I can't make them work. Can somebody help me simplify it? Here is my current query:


SELECT S1.First_Name,S1.Last_Name, P2.PRNAME, P1.PRACTSUM, (P1.PRACTSUM / 3600) as TimeAlloted, P4.PRSTART,P4.PRFINISH FROM CLARITY.PRTIMEENTRY P1 Inner Join clarity.prchargecode P2 on
P1.PRCHARGECODEID = p2.PRID Inner Join Clarity.prtimesheet P3 on
p3.PRID = P1.PRTIMESHEETID INNER JOIN CLARITY.srm_resources S1 ON
S1.ID = P3.PRRESOURCEID INNER JOIN clarity.prtimeperiod P4 ON
P4.PRID = P3.PRTIMEPERIODID
WHERE P1.PRASSIGNMENTID is null

Outcomes