--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]