22,302
社区成员




select distinct equ.OrgId, emp.EmpId, equ.EquID, A.SendOrderId, A.RegCode, A.BackupId, A.OrderTypeId, A.EquCode, A.ExecResultId,
A.ExecCount,A.ExecParams, cast(substring(a.Data,1,19) as DateTime) as ExecBeginDate, cast(substring(a.Data,20,19) as DateTime) as ExecEndDate,
Convert(Varchar(19),GetDate(),120) as LastDate, 1 as LastModified
into Tmp20170511105629729 from Openxml(@tmpMyDoc,'/U/G',2)
with (SendOrderID int 'SO', RegCode int 'F', BackupId int 'B', OrderTypeId int 'O', Data varchar(1000) 'D', EquCode int 'E', ExecResultId int 'S', ExecParams int 'P', ExecCount int 'C') a
inner join
equ_EquList equ on a.EquCode = equ.EquCode
left join sys_Emp emp on emp.RegCode = a.RegCode and emp.OrgID = equ.OrgID
where a.ExecResultId <> -4 and a.ExecResultId <> -7