sqlserver数据库临时表直插

 SELECT  ROW_NUMBER() OVER (ORDER BY TCFMDB.FPigID) FRowID, TCFMDB.FPigID, TCFMDB.FParityCount, TCFMDB.FMonoidID,
            NULL, TCFMDB.FCostItemID, tbfc.FCostItemTypeID, SUM(TCFMDB.FCreditMoney) FEndingBalance,
            3 AS FType,
    INTO    #T_AvgTemp
    FROM    dbo.T_FN_Cost_FAMakeDepreciationBalance TCFMDB
	INNER JOIN dbo.T_Base_FN_CostItem tbfc ON tbfc.FCostItemID = TCFMDB.FCostItemID
    WHERE   TCFMDB.FAccountUnitID = @FAccountUnitID
            AND TCFMDB.FYearPeriod = @FYearPeriod
            AND FMonoidID IN ( 7, 9 )
    GROUP BY TCFMDB.FAccountUnitID, TCFMDB.FPigID, TCFMDB.FParityCount, TCFMDB.FMonoidID, 
             TCFMDB.FCostItemID, tbfc.FCostItemTypeID;

直插临时表时报错

原因:查询列有空字段名导致的