Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Workflow.szDescription as szName,
- AIForm.szNumber AS szNumber,
- AI_WorkflowStage.szName AS szStage,
- Workflow.dtCreated,
- 'AccidentIncident' AS szType
- FROM AIForm INNER JOIN Workflow ON Workflow.ID = AIForm.WorkflowID
- INNER JOIN AI_WorkflowStage ON AI_WorkflowStage.WorkflowStageID = Workflow.WorkflowStageID AND AI_WorkflowStage.ClientID = :ClientID
- WHERE Workflow.CreatorID = :EmployeeID AND
- Workflow.bAvailable = 1
- UNION
- SELECT Workflow.szDescription AS szName,
- NonConformanceForm.szNumber AS szNumber,
- NonConformanceWorkflowStage.szName AS szStage,
- Workflow.dtCreated AS dtCreated,
- 'Improvement' AS szType
- FROM NonConformanceForm INNER JOIN Workflow ON Workflow.ID = NonConformanceForm.WorkflowID
- INNER JOIN NonConformanceWorkflowStage ON NonConformanceWorkflowStage.WorkflowStageID = Workflow.WorkflowStageID AND NonConformanceWorkflowStage.ClientID = :ClientID
- WHERE Workflow.CreatorID = :EmployeeID AND
- Workflow.bAvailable = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement