hi, check this query..

; with

RECORD_SET1(MIN_VALUE, MIN_TSTAMP)AS

(SELECT min(VALUE), min(T_STAMP) from @t

WHERE VALUE = (SELECT min(VALUE) FROM @t)),

RECORD_SET2(MAX_VALUE, MAX_TSTAMP)AS

(SELECT min(VALUE), min(T_STAMP) from @t

WHERE VALUE = (SELECT max(VALUE) FROM @t))

SELECT * FROM RECORD_SET1,RECORD_SET2;