Skip to content

Instantly share code, notes, and snippets.

@npero

npero/gist:6623260

Created September 19, 2013 13:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save npero/6623260 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save npero/6623260 to your computer and use it in GitHub Desktop.
Download ZIP
DB script to add missing UTG_THRESHOLDUNIT codedetail to Municipality. (cfr Henk and Rita request from Nova signet)
Raw
gistfile1.txt
INSERT into DICCODEDETAIL (IDDICCODE,IDSYSNOVAINSTANCE,IDDICMUNICIPALITY,CODEDETAIL,DESCRIPTION,LANGUAGE,RANKING,LASTUPDATE)
select * from (select IDDICCODE,2,IDDICMUNICIPALITY,CODEDETAIL,DESCRIPTION,LANGUAGE,RANKING, count(*) over ( partition by codedetail, language) total from diccodedetail a where iddiccode = 'UTG_THRESHOLDUNIT' ) where total = 1
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment