select *
from (select ROW_NUMBER()over(partition by docname order by priority,startdate desc) rownumber,* from #t)a
where rownumber=1