Skip to content

Instantly share code, notes, and snippets.

@doug1n
Created November 27, 2019 20:26
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save doug1n/443af01fca57e5e7c26a76f3f818bad2 to your computer and use it in GitHub Desktop.
Save doug1n/443af01fca57e5e7c26a76f3f818bad2 to your computer and use it in GitHub Desktop.
Script em SQL para obter a tabela do banco de dados passando o código do processo no Fluig
SELECT 'ML0010' + CONVERT(VARCHAR(10), l.COD_LISTA_PAI) AS 'TABELA_PRINCIPAL',
'ML0010' + CONVERT(VARCHAR(10), l.COD_LISTA_FILHO) AS 'TABELA_PAIxFILHO',
d.COD_LISTA,
l.COD_LISTA_PAI,
l.COD_LISTA_FILHO,
l.COD_TABELA ,
d.NUM_DOCTO_PROPRIED ,
d.NUM_VERS_PROPRIED
FROM DEF_PROCES p
LEFT JOIN VERS_DEF_PROCES vp ON vp.COD_DEF_PROCES = p.COD_DEF_PROCES
AND vp.LOG_ATIV = 1
LEFT JOIN DOCUMENTO d ON d.NR_DOCUMENTO = vp.NUM_PASTA_FORM
AND d.VERSAO_ATIVA = 1
LEFT JOIN SERV_DATASET ds ON ds.COD_DATASET = d.NM_DATASET
LEFT JOIN META_LISTA_REL l ON l.COD_LISTA_PAI = d.COD_LISTA
WHERE p.COD_DEF_PROCES = 'NOME_DO_PROCESSO'
ORDER BY vp.NUM_VERS DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment