Select w.NIT_No, w.WorkNo, wo.Amount, wo.Rate, wo.Quantity, wo.Unit, wo.ItemCode, wo.WorkOrderBoqID,wo.WorkOrderIssueDate from Works won w.WorkNo != wo.Work_No and w.NIT_No != wo.NIT
--IF OWNERGROUP IS MISSING (Location NOT NULL) SET wo.ownergroup='@'+SUBSTRING(wo.location,1,3)+'OwnerGroup'
FROM dbo.workorder AS wo INNER JOIN inserted AS i ON wo.wonum=i.wonumWHERE wo.status<>
下面是代码的示例:ceil(floor((wo.actfinish - p.periodstart+1))/7)) WHERE TRUNC (wo.actfinish) BETWEEN fp.periodstartAND fp.periodend) fin_period,
wo.wo8 as asse