Skip to content

Instantly share code, notes, and snippets.

@sqldeployhelmet

sqldeployhelmet/update_partition_readonly_FG

Created October 4, 2018 17:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sqldeployhelmet/c53ddc4ed645a793f5d86022480d23c8 to your computer and use it in GitHub Desktop.
Save sqldeployhelmet/c53ddc4ed645a793f5d86022480d23c8 to your computer and use it in GitHub Desktop.
Download ZIP
a general data warehouse update command
Raw
update_partition_readonly_FG
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';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment