Viewing post 1 (of 1 total)
dis 1 seems to b simple -
select distinct t1.orderid , t1.orderdata
from #tbl1 t1
inner join #tbl1 t2
on t1.datemodified > t2.datemodified
group by t1.orderid , t1.orderdata
February 14, 2007 at 3:06 am
#689648