Advertisement
Guest User

Untitled

a guest
Jul 27th, 2016
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. SELECT Workflow.szDescription as szName,
  2. AIForm.szNumber AS szNumber,
  3. AI_WorkflowStage.szName AS szStage,
  4. Workflow.dtCreated,
  5. 'AccidentIncident' AS szType
  6. FROM AIForm INNER JOIN Workflow ON Workflow.ID = AIForm.WorkflowID
  7. INNER JOIN AI_WorkflowStage ON AI_WorkflowStage.WorkflowStageID = Workflow.WorkflowStageID AND AI_WorkflowStage.ClientID = :ClientID
  8. WHERE Workflow.CreatorID = :EmployeeID AND
  9. Workflow.bAvailable = 1
  10.  
  11. UNION
  12.  
  13. SELECT Workflow.szDescription AS szName,
  14. NonConformanceForm.szNumber AS szNumber,
  15. NonConformanceWorkflowStage.szName AS szStage,
  16. Workflow.dtCreated AS dtCreated,
  17. 'Improvement' AS szType
  18. FROM NonConformanceForm INNER JOIN Workflow ON Workflow.ID = NonConformanceForm.WorkflowID
  19. INNER JOIN NonConformanceWorkflowStage ON NonConformanceWorkflowStage.WorkflowStageID = Workflow.WorkflowStageID AND NonConformanceWorkflowStage.ClientID = :ClientID
  20. WHERE Workflow.CreatorID = :EmployeeID AND
  21. Workflow.bAvailable = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement