DECLARE @workflowTable AS TABLE (company varchar(50), wor...


Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu Meta

Q&A about the site for Ubuntu users and developers

DECLARE @workflowTable AS TABLE (company varchar(50), workflow varchar(50), [date] datetime, cancel varchar(50), score int)
('CompanyA',      'Workflow27',     'June 5 2011',    'N',  1)
,('CompanyA',      'Workflow27',     'June 8 2011',   'N',  2)
,('CompanyA',      'Workflow27',     'June 8 2011',   'N',  3)
,('CompanyA',      'Workflow27',     'June 12 2011',  'Y',  15)
,('CompanyB',      'Workflow13',     'Apr 4 2011',    'Y',  5)
,('CompanyB',      'Workflow13',     'Apr 9 2011',    'N',  9)
,('CompanyB',      'Workflow20',     'Dec 11 2011',   'Y',  12)
,('CompanyB',      'Workflow20',     'Dec 17 2011',   'N',  8)

;WITH partitioned AS (
        SELECT company
            ,ROW_NUMBER() OVER(PARTITION BY company, workflow
                                ORDER BY date) AS seq
        FROM @workflowTable
    SELECT workflow, cancel, sum(score)
    FROM partitioned WHERE seq = 2
    group by workflow, cancel

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results