tags:

views:

14

answers:

1

I have the pivot

PIVOT
    (
        MIN(DateId)
        FOR Stage IN
        (
            [Start], [Alpha], [Beta], [Release]
        )
    ) as p

I only want the MIN for the [Start] column and Max for every other column. How would I go about achieving this?