--Sample Data
declare @tbl table
(
id int primary key
,field_1 date
,field_2 date
,field_3 date
)
insert into @tbl values(1,'20120823','20120824','20120825')
--Query
select max(a.mydate),a.id
from (
select id,MAX(field_1) mydate from @tbl group by id
union all
select id,MAX(field_2) from @tbl group by id
union all
select id,MAX(field_3) from @tbl group by id
)a
group by a.id
I think this is what required for you.......
So, from the next time whenever you post a query make sure that you provide sample data like above so that one can easily answer your query.........
[font="Comic Sans MS"]Vishwanath[/font]