Carry Estimates/Time logged

carry_over_estimates.sql

select
  t.PrtID as TicketID,
  t.PrtMinutesEstimated as TicketEstimateInMin,
  a.PrtPtscID as ScrumID,
  s.PtspID as SprintID,
  s.PrtMinutesEstimated as SprintEstimateInMin,
  tt.PttMinutes as TimeLoggedInMin,
  tt.PttEmID as TimeLoggedEmployee,
  tt.PttDate as TimeLoggedDate
from csn_internaltools.dbo.tblPTTask t
inner join csn_internaltools.dbo.tblPTTaskExtAgile a
  on t.PrtID = a.PrtID
inner join csn_internaltools.dbo.tbljoinPTTaskPTSprints s
  on t.PrtID = s.PrtID
inner join csn_internaltools.dbo.tblPTTaskTime tt
  on t.PrtID = tt.PttPrtID
and t.PrtID in
    (
      -- Tickets that have been in multiple sprints (carry over tickets)
      select PrtID from csn_internaltools.dbo.tbljoinPTTaskPTSprints
      group by PrtID
      having count(PrtID) > 1
    )