Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO OPENQUERY(SGE_PRODUCAO,'SELECT id, cpf, token, codigo FROM CO_BIBLIOTECA_VIRTUAL') select ID, CPF, SUBSTRING(master.dbo.fn_varbintohexstr(HASHBYTES('MD5', RIGHT('0000000' + CONVERT(VARCHAR(7), ID), 7) + 'rPtO0JBhw1lqslXMMwxvGQQ08vuyviip')), 3, 32) TOKEN, RIGHT('0000000' + CONVERT(VARCHAR(7), ID), 7) CODIGO from Tbl_UsuarioBibliotecaVirtual where datediff(day,dataCadastro,getdate()) = 0 and IdTipoUsuario = 97 AND CPF COLLATE Latin1_General_CI_AS NOT IN (SELECT CPF COLLATE Latin1_General_CI_AS FROM OPENQUERY(SGE_PRODUCAO,'SELECT CPF FROM CO_BIBLIOTECA_VIRTUAL') WHERE CPF = CPF)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement