What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
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.