Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement