SELECT *, 'Step ' + CAST(Step AS VARCHAR(20)) + ' - ' + StepTitle AS StepSummary FROM Wf.WorkflowTemplateSteps WTS INNER JOIN Wf.WorkflowTemplates WT ON WTS.WorkflowTemplateID = WT.WorkflowTemplateID INNER JOIN Wf.Workflows W ON WT.WorkflowID = W.WorkflowID ORDER BY W.WorkflowID, WTS.Step