New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
DECLARE @Project VARCHAR(30), @Phase VARCHAR(7), @Task VARCHAR(7), @custThroughDate DATETIME, Set @Project = '01080901' Set @Phase = '0301' Set @Task = '00' Set @custThroughDate = '5/29/2009' Select Project as Project, Phase as Phase, Task as Task, vwAA_BRRecTypeBillStatus.RecType, vwAA_BRRecTypeBillStatus.DetailGrouping, TransDate, CASE WHEN RecType IN ('Labor','Unposted') AND Transdate >= DATEADD(dd, - DATEPART(dw, CONVERT(varchar, @custThroughDate, 101)), CONVERT(varchar, @custThroughDate, 101)) AND Transdate <= @custThroughDate THEN RegHrs + OvtHrs + SpecialOvtHrs ELSE '' END AS CurrentWeekHrs FROM vwAA_BRRecTypeBillStatus where Project = @Project AND Phase = @Phase AND Task = @Task
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.