document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. SELECT
  2. VALID_TO_DT AS LOAD_DT,
  3. @Tran_hist_start AS END_DT
  4. VALID_FROM_DT AS VALID_FROM_DT
  5. VALID_TO_DT AS VALID_TO_DT
  6. VALUE AS VALUE
  7. FROM BITABLE AS HOR_NEWHIST
  8. WHERE
  9. HOR_NEWHIST.LOAD_DT= @Tran_hist_start
  10. AND VALID_FROM_DT < (SELECT MAX(VALID_FROM_DT) FROM BITABLE WHERE LOAD_DT= @Tran_hist_start)
');