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?