index_col = ("Proc_Trial Type")) # Select rows with "Flanker" as the trial type mrd2["Flanker"] # Eliminate rows which have "Practice" in the Proc_Shuffle 1 column mrd3= mrd2[-mrd2[&qu
Ten.Account, SUM(T.fInclusiveAmount)AS BilledAmount, MRD.fCurrentReading , T.cDescription
from _mtblTransactionsleft join _etblPeriod PER ON T.iPeriodID = PER.idPeri
, ClaimRepairs.ConfirmedOnSiteDate) - (datediff(wk, MRD.DeploymentDate, ClaimRepairs.ConfirmedOnSiteDate) * 2) - when datepart(dw, MRD.DeploymentDate) = 1 then 1 else 0 endIS NOT NULL AND ClaimRepairs.ConfirmedOnSiteDate IS NULL
THEN datedif