I was hoping someone could help me with a piece of the formula to get me to my ultimate goal.
PR_HIST_MOVIM_PEDID table
LOGTable
PR_HIST_MOVIM_PEDIDtablehasorderstatusbyday,butwhenyouturnthemonth,itlosesinformation.ALOGtablehasonelasttransitionofeachrequestperdayanditisthistablethatisthecorrectreference.Ihavetocreateanewtablethatshowsmealltherequestsandtheirdayswithoutlosinginformationassoonastheexchangeofmonthshappens.
Example: 
NOTE: Note that this is a small example. My database table has tens of thousands of values.
How to get the final result?