0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

DECLARE @workflowTable AS TABLE (company varchar(50), workflow varchar(50), [date] datetime)
INSERT INTO @workflowTable VALUES
('CompanyA',      'Workflow27',     'June 5 2011')
,('CompanyA',      'Workflow27',     'June 8 2011')
,('CompanyA',      'Workflow27',     'June 12 2011')
,('CompanyB',      'Workflow13',     'Apr 4 2011')
,('CompanyB',      'Workflow13',     'Apr 9 2011')
,('CompanyB',      'Workflow20',     'Dec 11 2011')
,('CompanyB',      'Workflow20',     'Dec 17 2011')

;WITH partitioned AS (
        SELECT company
            ,workflow
            ,date
            -- ,other_columns
            ,ROW_NUMBER() OVER(PARTITION BY company, workflow
                                ORDER BY date) AS seq
        FROM @workflowTable
    )
    SELECT *
    FROM partitioned WHERE seq = 1

view current version

edited apr 20 11

created apr 20 11 Cade Roux