SELECT [Vw_WorkflowInstanceDocuments].[WorkflowInstanceDocumentID] AS [WorkflowInstanceDocumentID], [Vw_WorkflowInstanceDocuments].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_WorkflowInstanceDocuments].[DocumentTypeID] AS [DocumentTypeID], [Vw_WorkflowInstanceDocuments].[DocumentID] AS [DocumentID], [Vw_WorkflowInstanceDocuments].[IsMandatory] AS [IsMandatory], [Vw_WorkflowInstanceDocuments].[IsCancelled] AS [IsCancelled], [Vw_WorkflowInstanceDocuments].[IsExpiryDateRequired] AS [IsExpiryDateRequired], [Vw_WorkflowInstanceDocuments].[ExpiryDate] AS [ExpiryDate], [Vw_WorkflowInstanceDocuments].[Title] AS [Title], [Vw_WorkflowInstanceDocuments].[DocumentDescription] AS [DocumentDescription], [Vw_WorkflowInstanceDocuments].[IsDocumentTitleEditable] AS [IsDocumentTitleEditable], [Vw_WorkflowInstanceDocuments].[DocumentVerificationStatusID] AS [DocumentVerificationStatusID] FROM [Wf].[Vw_WorkflowInstanceDocuments] AS [Vw_WorkflowInstanceDocuments] SELECT [Vw_WorkflowInstances].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_WorkflowInstances].[WorkflowInstanceDescription] AS [WorkflowInstanceDescription], [Vw_WorkflowInstances].[WorkflowStartDate] AS [WorkflowStartDate], [Vw_WorkflowInstances].[WorkflowEndDate] AS [WorkflowEndDate], [Vw_WorkflowInstances].[CreatedByID] AS [CreatedByID], [Vw_WorkflowInstances].[CreatedDate] AS [CreatedDate], [Vw_WorkflowInstances].[WorkflowInstanceStatusID] AS [WorkflowInstanceStatusID], [Vw_WorkflowInstances].[WorkflowInstanceStatus] AS [WorkflowInstanceStatus], [Vw_WorkflowInstances].[WorkflowTemplateID] AS [WorkflowTemplateID], [Vw_WorkflowInstances].[WorkflowTemplateStepID] AS [WorkflowTemplateStepID], [Vw_WorkflowInstances].[EntityID] AS [EntityID], [Vw_WorkflowInstances].[ItemID] AS [ItemID], [Vw_WorkflowInstances].[ReferenceNumber] AS [ReferenceNumber], [Vw_WorkflowInstances].[Description] AS [Description], [Vw_WorkflowInstances].[WorkflowID] AS [WorkflowID], [Vw_WorkflowInstances].[DashboardControllerName] AS [DashboardControllerName], [Vw_WorkflowInstances].[WorkflowControllerName] AS [WorkflowControllerName], [Vw_WorkflowInstances].[Reference] AS [Reference], [Vw_WorkflowInstances].[WarningDate] AS [WarningDate], [Vw_WorkflowInstances].[DueDate] AS [DueDate], [Vw_WorkflowInstances].[WorkflowFriendlyName] AS [WorkflowFriendlyName], [Vw_WorkflowInstances].[UpdatedByID] AS [UpdatedByID], [Vw_WorkflowInstances].[UpdatedDate] AS [UpdatedDate], [Vw_WorkflowInstances].[ASsignedTo] AS [ASsignedTo], [Vw_WorkflowInstances].[CreatedByName] AS [CreatedByName], [Vw_WorkflowInstances].[WorkflowInstanceStateID] AS [WorkflowInstanceStateID], [Vw_WorkflowInstances].[WorkflowInstanceState] AS [WorkflowInstanceState], [Vw_WorkflowInstances].[WorkflowInstanceAge] AS [WorkflowInstanceAge], [Vw_WorkflowInstances].[StepNumber] AS [StepNumber], [Vw_WorkflowInstances].[StepTitle] AS [StepTitle] FROM [Wf].[Vw_WorkflowInstances] AS [Vw_WorkflowInstances] SELECT [Vw_WorkflowInstanceTasks].[WorkflowInstanceTaskID] AS [WorkflowInstanceTaskID], [Vw_WorkflowInstanceTasks].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_WorkflowInstanceTasks].[WorkflowInstanceTaskStatusID] AS [WorkflowInstanceTaskStatusID], [Vw_WorkflowInstanceTasks].[WorkflowTemplateStepID] AS [WorkflowTemplateStepID], [Vw_WorkflowInstanceTasks].[DateCreated] AS [DateCreated], [Vw_WorkflowInstanceTasks].[DateCompleted] AS [DateCompleted], [Vw_WorkflowInstanceTasks].[AssignedToID] AS [AssignedToID], [Vw_WorkflowInstanceTasks].[CompletedByID] AS [CompletedByID], [Vw_WorkflowInstanceTasks].[Description] AS [Description], [Vw_WorkflowInstanceTasks].[Comments] AS [Comments], [Vw_WorkflowInstanceTasks].[TaskStatusDescription] AS [TaskStatusDescription], [Vw_WorkflowInstanceTasks].[WorkflowTemplateStepNumber] AS [WorkflowTemplateStepNumber], [Vw_WorkflowInstanceTasks].[WorkflowTemplateStepTitle] AS [WorkflowTemplateStepTitle], [Vw_WorkflowInstanceTasks].[WorkflowTemplateStepDurationOvertime] AS [WorkflowTemplateStepDurationOvertime], [Vw_WorkflowInstanceTasks].[WorkflowTemplateStepTypeID] AS [WorkflowTemplateStepTypeID], [Vw_WorkflowInstanceTasks].[WorkflowTemplateStepTypeDescription] AS [WorkflowTemplateStepTypeDescription], [Vw_WorkflowInstanceTasks].[AssignedToName] AS [AssignedToName], [Vw_WorkflowInstanceTasks].[CompletedByName] AS [CompletedByName], [Vw_WorkflowInstanceTasks].[WorkflowInstanceEntityID] AS [WorkflowInstanceEntityID], [Vw_WorkflowInstanceTasks].[WorkflowInstanceItemID] AS [WorkflowInstanceItemID], [Vw_WorkflowInstanceTasks].[WorkflowInstanceReference] AS [WorkflowInstanceReference], [Vw_WorkflowInstanceTasks].[WorkflowInstanceCreatedDate] AS [WorkflowInstanceCreatedDate], [Vw_WorkflowInstanceTasks].[WorkflowInstanceCreatedByID] AS [WorkflowInstanceCreatedByID], [Vw_WorkflowInstanceTasks].[WorkflowInstanceCreatedByName] AS [WorkflowInstanceCreatedByName], [Vw_WorkflowInstanceTasks].[WorkflowID] AS [WorkflowID], [Vw_WorkflowInstanceTasks].[WorkflowFriendlyName] AS [WorkflowFriendlyName], [Vw_WorkflowInstanceTasks].[WorkflowControllerName] AS [WorkflowControllerName], [Vw_WorkflowInstanceTasks].[TaskDuration] AS [TaskDuration], [Vw_WorkflowInstanceTasks].[EscalatedFromID] AS [EscalatedFromID] FROM [Wf].[Vw_WorkflowInstanceTasks] AS [Vw_WorkflowInstanceTasks] SELECT [Vw_WorkflowTemplates].[WorkflowID] AS [WorkflowID], [Vw_WorkflowTemplates].[WorkflowFriendlyName] AS [WorkflowFriendlyName], [Vw_WorkflowTemplates].[WorkflowDescription] AS [WorkflowDescription], [Vw_WorkflowTemplates].[WorkflowControllerName] AS [WorkflowControllerName], [Vw_WorkflowTemplates].[EntityName] AS [EntityName], [Vw_WorkflowTemplates].[WorkflowTemplateID] AS [WorkflowTemplateID], [Vw_WorkflowTemplates].[WorkflowTemplateStatusID] AS [WorkflowTemplateStatusID], [Vw_WorkflowTemplates].[Version] AS [Version], [Vw_WorkflowTemplates].[TotalRequestsInPogress] AS [TotalRequestsInPogress] FROM [Wf].[Vw_WorkflowTemplates] AS [Vw_WorkflowTemplates] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore] [ScriptIgnore]