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;