• My bad, I was referring to

    INSERT INTO #Results

    EXEC sp_executesql N'SELECT col_1, col_2 FROM A;';

    can I use

    INSERT INTO #Results

    SELECT col_1, col_2 FROM A;