。select * into 有关问题_Sql Server

求助。select * into 问题


            select * into #TempNewCostCenter from   
            (
            		select  distinct substring(CostCenter,5,LEN(CostCenter)) as CostCenter,[Description],GETDATE() as lastUpdateTime,'Open' as Status
		FROM MDE_CostCenter T
		WHERE  CostCenter  IS NOT NULL
                        AND NOT EXISTS ( SELECT 1
                                         FROM   dbo.tbl_ExternalTable_CostCenter g
                                         WHERE   substring(t.CostCenter,5,LEN(t.CostCenter))= g.CostCenter
                                        )
                           and substring(t.CostCenter,5,LEN(t.CostCenter))<>'DUMMY' and  ISNUMERIC(substring(t.CostCenter,5,LEN(t.CostCenter)))=0
                    AND NOT EXISTS(
                    SELECT 1
                                         FROM   dbo.tbl_ExternalTable_CostCenter g
                                         WHERE   t.Description= g.CCName
                             )
                             
            ) 

执行报错。问题在哪里?

Msg 102, Level 15, State 1, Line 17
Incorrect syntax near ')'.

------解决思路----------------------
select * into #TempNewCostCenter from
            (
                    select  distinct substring(CostCenter,5,LEN(CostCenter)) as CostCenter,[Description],GETDATE() as lastUpdateTime,'Open' as Status
        FROM MDE_CostCenter T
        WHERE  CostCenter  IS NOT NULL
                        AND NOT EXISTS ( SELECT 1
                                         FROM   dbo.tbl_ExternalTable_CostCenter g
                                         WHERE   substring(t.CostCenter,5,LEN(t.CostCenter))= g.CostCenter
                                        )
                           and substring(t.CostCenter,5,LEN(t.CostCenter))<>'DUMMY' and  ISNUMERIC(substring(t.CostCenter,5,LEN(t.CostCenter)))=0
                    AND NOT EXISTS(
                    SELECT 1
                                         FROM   dbo.tbl_ExternalTable_CostCenter g
                                         WHERE   t.Description= g.CCName
                             )

            ) A  加个别名
------解决思路----------------------


select  distinct substring(a.CostCenter,5,LEN(CostCenter)) as CostCenter,a.[Description],GETDATE() as lastUpdateTime,'Open' as Status
into #TempNewCostCenter
FROM MDE_CostCenter a
left join dbo.tbl_ExternalTable_CostCenter b on substring(a.CostCenter,5,LEN(a.CostCenter))= b.CostCenter
left join dbo.tbl_ExternalTable_CostCenter c on a.[Description]= c.CCName
WHERE  a.CostCenter  IS NOT NULL
and substring(a.CostCenter,5,LEN(t.CostCenter))<>'DUMMY' 
and  ISNUMERIC(substring(a.CostCenter,5,LEN(t.CostCenter)))=0
and b.主鍵 is null and c.主鍵 is null