Viewing 2 posts - 1 through 2 (of 2 total)
--sample Data
declare @tbl table
(
id int
,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...
September 24, 2012 at 11:58 pm
#1541652
--Sample Data
id int primary key
...
September 24, 2012 at 11:47 pm
#1541651