(SELECT 'AnalysisType', '13') UNION ALL
(SELECT 'FilterId', convert(nvarchar,@_FilterId)) UNION ALL
(SELECT 'MaximumCount', '10000') UNION ALL
(SELECT 'IncludeDurations', 'TRUE') UNION ALL
(SELECT 'CostType', '1') UNION ALL
(SELECT 'Title', 'Flow Analysis from Script') UNION ALL
(SELECT 'SheetName', 'Flow Sheet') UNION ALL
(SELECT 'TargetTable', '#DataTableResult') UNION ALL
(SELECT 'Show', 'TRUE') UNION ALL
(SELECT * from #_ViewSettings where [Name] = 'MinTransitionUsagePercentage')
--#GetAnalysis

--SELECT * FROM #DataTableResult; 
--(SELECT 'Title', 'Report1') UNION ALL
--(SELECT 'SheetName', 'Sheet1') UNION ALL
--(SELECT 'MaximumCount', '0') 
----#ShowReport 

SELECT distinct (Start)
into #DataTableEventTypes_tmp
FROM #DataTableResult
Where [Start] <> 'START'

SELECT ROW_NUMBER() OVER(ORDER BY [Start]) as [num], [Start]
INTO #DataTableEventTypes
FROM #DataTableEventTypes_tmp

-- BPMN 2.0 export below

-- Common definitions
SELECT '<?xml version="1.0" encoding="UTF-8"?>' as [str] UNION ALL
SELECT '<bpmn2:definitions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmn2="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:dc="http://www.omg.org/spec/DD/20100524/DC" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" id="definitionsId" name="QPR ProcessAnalyzerModel">' UNION ALL
SELECT '<bpmn2:process id="processId" name="Simple Process">' UNION ALL
SELECT '<bpmn2:startEvent id="START" name="START"> </bpmn2:startEvent>' UNION ALL 
SELECT '<bpmn2:endEvent id="END" name="END"> </bpmn2:endEvent>' UNION ALL 

-- BPMN Tasks

SELECT '<bpmn2:task id="' + convert(nvarchar,Start) + '" name="' + convert(nvarchar,Start) + '"> </bpmn2:task>' FROM #DataTableEventTypes UNION ALL 

-- BPMN sequence flows

SELECT '<bpmn2:sequenceFlow id="' + convert(nvarchar,Start) + '_' + convert(nvarchar,[End])
+ '" name="" sourceRef="' + convert(nvarchar,Start)
+ '" targetRef="' + convert(nvarchar,[End]) + '"/>'
FROM #DataTableResult UNION ALL

SELECT '</bpmn2:process>' UNION ALL

-- BPMN Diagram definitions

SELECT '<bpmndi:BPMNDiagram id="BPMNDiagram_2"> <bpmndi:BPMNPlane id="BPMNPlane_2" bpmnElement="processId">' UNION ALL
SELECT '<bpmndi:BPMNShape id="BPMNShape_START" bpmnElement="START"> <dc:Bounds height="80.0" width="100.0" x="0.0" y="0.0"/>  </bpmndi:BPMNShape>' UNION ALL
SELECT '<bpmndi:BPMNShape id="BPMNShape_END" bpmnElement="END"> <dc:Bounds height="80.0" width="100.0" x="200.0" y="0.0"/>  </bpmndi:BPMNShape>' UNION ALL

-- BPMN Diagram Shapes

SELECT '<bpmndi:BPMNShape id="BPMNShape_' + convert(nvarchar,Start) + '" bpmnElement="' + convert(nvarchar,Start) + '"> <dc:Bounds height="80.0" width="100.0" x="'+convert(nvarchar,num*20.0)+'" y="'+convert(nvarchar,num*20.0)+'"/>  </bpmndi:BPMNShape>' FROM #DataTableEventTypes UNION ALL 

-- BPMN Diagram Edges

SELECT '<bpmndi:BPMNEdge id="BPMNEdge_' + convert(nvarchar,Start) + '_' + convert(nvarchar,[End])
+ '" bpmnElement="'+ convert(nvarchar,Start) + '_' + convert(nvarchar,[End])
+ '" sourceElement="BPMNShape_' + convert(nvarchar,Start)
+ '" targetElement="BPMNShape_' + convert(nvarchar,[End]) + '"/>'
FROM #DataTableResult UNION ALL

SELECT '</bpmndi:BPMNPlane></bpmndi:BPMNDiagram>' UNION ALL

SELECT '</bpmn2:definitions>'; 

(SELECT 'Title', 'BPMN 2.0 Export') UNION ALL
(SELECT 'SheetName', 'BPMN 2_0') UNION ALL
(SELECT 'MaximumCount', '0') 
--#ShowReport 

SELECT 'MessageText', 'BPMN 2.0 Export completed' 
--#Exit