How do I make an Insert into using dynamic SQL and run sp_executesql?

Question

I am trying to make an Insert using cursor and execute sp_executesql using variable, the first time it ran and did not return anything, I went to the table and had not added any record. Then I ran the second time and the duplicate key message appeared, but no record was added to the table.

Does anyone have any idea what might be happening and where I’m failing? Below follows the code I’m trying to do.

'''

    SET NOCOUNT ON;
    Begin
        DECLARE @COLUNA VARCHAR(100), @COLUNAS VARCHAR(MAX), @CLONAR NVARCHAR(MAX), @NovoId int, @PedidoId varchar(11), @vInsertInto NVARCHAR(MAX);

        --- Inicializar a variavel
        SET @COLUNAS    = ''
        SET @NovoId     = ''
        SET @CLONAR     = ''
        SET @PedidoId   = '1234'

        --sempre declare que o cursor é do tipo LOCAL FAST_FORWARD.
        --Local diz que é o scopo da execuçao e FAST_FORWARD significa que ele so vai pra frente.
        DECLARE CURCOLUNAS CURSOR LOCAL FAST_FORWARD FOR SELECT COLUMN_NAME
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE   TABLE_CATALOG   = 'banco'
                AND TABLE_SCHEMA= 'dbo'
                AND TABLE_NAME  = 'tabela'
        ORDER BY ORDINAL_POSITION
        OPEN CURCOLUNAS
            FETCH NEXT FROM CURCOLUNAS INTO @COLUNA
            WHILE @@FETCH_STATUS = 0
            BEGIN
                SET @COLUNAS = @COLUNAS + ',' + @COLUNA
                FETCH NEXT FROM CURCOLUNAS INTO @COLUNA --- O into nesta linha
            END

            SET @COLUNAS= Right(@COLUNAS, len(@COLUNAS)-1)
            --SET @CLONAR = N'SELECT '+@COLUNAS+' FROM tabela WHERE Id = '+@PedidoId;
            SET @vInsertInto = N'INSERT INTO tabela ('+@COLUNAS+') SELECT '+@COLUNAS+' FROM tabela WHERE Id = '+@PedidoId;

            SET IDENTITY_INSERT [banco].[dbo].[tabela] ON
            --EXECUTE sp_executesql @CLONAR;
            EXECUTE sp_executesql @vInsertInto;
            SET IDENTITY_INSERT [banco].[dbo].[tabela] OFF

        --SET @NovoId=SCOPE_IDENTITY()
        --RETURN  @NovoId
        CLOSE CURCOLUNAS;
        DEALLOCATE CURCOLUNAS;
    End

'''