如何使用额外列将临时表添加到另一个临时表

CREATE TABLE #EmpPcodes
(
   YearMonth        INT,
   YEAR             INT,
   MONTH            INT,
   RunNo            INT,
   Amount           NUMERIC(18, 3),
   GroupCode        NvarCHAR(30),
   GroupName        NvarCHAR(250),
   GroupAName       NvarCHAR(250),
   PayrollGroup     INT,
   EmployeeId       INT
)    
CREATE TABLE #pArrangeAllcode
(
   YearMonth        INT,
   YEAR             INT,
   MONTH            INT,
   RunNo            INT,
   Amount           NUMERIC(18, 3),
   GroupCode        NvarCHAR(30),
   GroupName        NvarCHAR(250),
   GroupAName       NvarCHAR(250),
   PayrollGroup     INT,
   EmployeeId       INT,
   CodeArrange      INT
)

INSERT INTO #pArrangeAllcode 
SELECT YearMonth, YEAR, MONTH, RunNo, Amount, GroupCode, GroupName, 
GroupAName, PayrollGroup, EmployeeId,
FROM dbo.#EmpPcodes 

SELECT * FROM #pArrangeAllcode
CREATE TABLE #EmpPcodes
(
   YearMonth        I