Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!