Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
a small change in the data warehouse update script to avoid touching the read-only file group
UPDATE DW_DBNAME.dbo.DW_TABLE
SET ETL_JOB_SEQ_NUM = 1027140 ,
ETL_IUD_CD = 'D' ,
ETL_UPD_DTM = CONVERT(DATETIME, '03/16/2016 01:01:17')
WHERE ETL_VERS_START_DTM = CONVERT(DATETIME, '12/27/2014 00:26:24.137')
AND ACCT_NO = '5001194157'
AND ACCT_TYPE = 'ILN'
AND ETL_VERS_END_DTM > '2115-01-01';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment