SET IDENTITY_INSERT [portal_cliente_online_tortal].[dbo].[Usuario] ON;
INSERT INTO [portal_cliente_online_tortal].[dbo].[Usuario]
    (id, cnpj, cd_equipe_venda, cd_escritorio_venda, cpf, email, email_token, fl_ativo, fl_verificado, login, senha)
SELECT
    u.id AS id,
    1 AS cnpj, --case when LEN(u.cpf_CNPJ) > 11 then u.CPF_CNPJ else NULL end as cnpj,
    1 AS cd_equipe_venda, --cast(u.CD_ASSESSOR as int) as cd_equipe_venda,
    1 AS cd_escritorio_venda, --cast(u.CD_ESCRITORIO_VENDA as int) as cd_escritorio_venda,
    2 AS cpf, --case when LEN(u.CPF_CNPJ) = 11 then u.CPF_CNPJ else NULL end as cpf,
    'email' AS email, --u.EMAIL as email,
    'token' AS email_token, --u.TOKEN_VERIFICACAO_EMAIL as email_token,
    1 AS fl_ativo, --u.FL_ATIVO as fl_ativo,
    1 AS fl_verificado, --u.FL_EMAIL_VERIFICADO as fl_verificado,
    'login' AS login, --u.LOGIN as login,
    'PwViAZempBlrbA' AS senha
FROM [portal_cliente_online].[dbo].[TB_USUARIO] u;
SET IDENTITY_INSERT [portal_cliente_online_tortal].[dbo].[Usuario] OFF;