SELECT
VALID_TO_DT AS LOAD_DT,
@Tran_hist_start AS END_DT
VALID_FROM_DT AS VALID_FROM_DT
VALID_TO_DT AS VALID_TO_DT
VALUE AS VALUE
FROM BITABLE AS HOR_NEWHIST
WHERE
HOR_NEWHIST.LOAD_DT= @Tran_hist_start
AND VALID_FROM_DT < (SELECT MAX(VALID_FROM_DT) FROM BITABLE WHERE LOAD_DT= @Tran_hist_start)