Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
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.
|Upgrade SQL Server 2014 Standard Edition from SQL Server 2012 Standard Edition||14||37|
|Connect remotely to SQL Server DB without TCP/IP enabled?||2||37|
|T-SQL Query - Group By Year||3||32|
|T-SQL: Need Group By to use "fuzzy logic"??||3||27|