Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Declare @WORouting Table ( WONbr float, OpCode float, OpCodeDesc nvarchar(100), EstHours float, ActHours float, EmpNbr float, EmpName nvarchar(100), WAITM float ) Insert @WORouting (WONbr, OpCode , OpCodeDesc , EstHours , ActHours, EmpNbr , EmpName , WAITM ) Select wo.WONbr, f3003.IROPSQ / 100, f3003.IRDSC1, f3003.IRRUNL, sum(f31122.wthrw / 100), f31122.wtan8, '', f3003.IRKIT from @WorkOrders wo inner join ps_prod.proddta.f3003 f3003 (nolock) on wo.waitm = f3003.irkit and ltrim(rtrim(f3003.IRMMCU)) = '308' inner join ps_prod.proddta.f31122 f31122 (nolock) on f3003.irkit = f31122.wtkit and f3003.iropsq = f31122.wtopsq group by wo.WONbr, f3003.IROPSQ / 100, f3003.IRDSC1, f3003.IRRUNL, f31122.wtan8, f3003.IRKIT
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.