INSERT INTO [portal_cliente_online_tortal].[dbo].[Usuario]
    (cnpj, cd_equipe_venda, cd_escritorio_venda, cpf, email, email_token, fl_ativo, fl_verificado, login, senha)
SELECT DISTINCT
    CASE WHEN LEN(u.cpf_CNPJ) > 11 THEN u.CPF_CNPJ ELSE NULL END AS cnpj,
    CAST(u.CD_ASSESSOR AS INT) AS cd_equipe_venda,
    CAST(u.CD_ESCRITORIO_VENDA AS INT) AS cd_escritorio_venda,
    CASE WHEN LEN(u.CPF_CNPJ) = 11 THEN u.CPF_CNPJ ELSE NULL END AS cpf,
    u.EMAIL AS email,
    'null' AS token, --u.TOKEN_VERIFICACAO_EMAIL as email_token,
    u.FL_ATIVO AS fl_ativo,
    u.FL_EMAIL_VERIFICADO AS fl_verificado,
    u.LOGIN AS login,
    'PwViAZempBlrbA' AS senha
FROM [portal_cliente_online].[dbo].[TB_USUARIO] u;