Hi,, After doing my best try,

I believe, below query should work.

SELECT o.*,

COALESCE( NULLIF( o.t_wght, 0), x.t_wght,y.t_wght, 0)

FROM [TBRTEK002] o

OUTER APPLY (

SELECT top 1 i.t_wght

FROM [TBRTEK002] i

WHERE i.t_mcno = o.t_mcno

AND i.t_citg = o.t_citg

AND i.t_trdt = o.t_trdt

AND i.t_shft < o.t_shft

AND i.t_wght > 0

ORDER BY i.t_shft DESC

) x

OUTER APPLY (

SELECT top 1 c.t_wght as t_wght

FROM [TBRTEK002] c

WHERE c.t_mcno = o.t_mcno

AND c.t_citg = o.t_citg

AND C.t_trdt < o.t_trdt

AND c.t_wght > 0

ORDER BY c.t_shft desc

) y

WHERE o.t_mcno = 'F01'

ORDER BY [t_mcno],[t_citg],[t_trdt] desc,[t_shft] desc

Thanks