求好手 帮助

if OBJECT_ID('tempdb.dbo.#bus_BusinessDetail') is not null drop table #bus_BusinessDetail
if OBJECT_ID('tempdb.dbo.#cost_FeeInfo') is not null drop table #cost_FeeInfo
if OBJECT_ID('tempdb.dbo.#customs_CustomsDeclaration') is not null drop table #customs_CustomsDeclaration
CREATE TABLE [#bus_BusinessDetail](     
[Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[BusinessNum] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,     
[Consignor] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,  
CONSTRAINT [PK_BUS_BUSINESSDETAIL] PRIMARY KEY NONCLUSTERED  
(     [Id] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]   


CREATE TABLE [#cost_FeeInfo](     
[Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[BusinessNum] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,     
[Flag_ManagerCheckCost] [varchar](1) COLLATE Chinese_PRC_CI_AS NULL,  
CONSTRAINT [PK_COST_FEEINFO] PRIMARY KEY NONCLUSTERED  (     [Id] ASC)
WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] )   


CREATE TABLE [#customs_CustomsDeclaration](    
[Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
 [BusinessNum] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,     
 [AdvanceNum] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,     
 [DeclareDate] [datetime] NULL,     
 [DeliveryListNum] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,     
 [Declare_Name] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,  
 CONSTRAINT [PK_CUSTOMS_CUSTOMSDECLARATION] PRIMARY KEY NONCLUSTERED  (     [Id] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] 
----------------------------------------------------------
insert into #bus_BusinessDetail(BusinessNum,Consignor) 
values ('RPO201310000001','A公司')
insert into #bus_BusinessDetail(BusinessNum,Consignor) 
values('RPI201310000015','B公司')
insert into #bus_BusinessDetail(BusinessNum,Consignor) 
values('RPI201310000016','A公司')
insert into #bus_BusinessDetail(BusinessNum,Consignor) 
values('BPO103942','A公司')
insert into #bus_BusinessDetail(BusinessNum,Consignor) 
values('YLO201310001539','A公司')
------------------------------------------------------------
insert into #cost_FeeInfo ([BusinessNum],[Flag_ManagerCheckCost])
	values ('RPO201310000001','0')
insert into #cost_FeeInfo ([BusinessNum],[Flag_ManagerCheckCost])
	values('RPO201310000001','0')
insert into #cost_FeeInfo ([BusinessNum],[Flag_ManagerCheckCost])
	values('RPI201310000015','0' )
insert into #cost_FeeInfo ([BusinessNum],[Flag_ManagerCheckCost])
	values('RPI201310000015','1' )
insert into #cost_FeeInfo ([BusinessNum],[Flag_ManagerCheckCost])
	values('RPI201310000016','1')
insert into #cost_FeeInfo ([BusinessNum],[Flag_ManagerCheckCost])
	values('RPI201310000016','1') 
------------------------------------------------------------
insert into #customs_CustomsDeclaration ([BusinessNum],[AdvanceNum],[DeliveryListNum],[DeclareDate],[Declare_Name])
values ('RPO201310000001',null,null,'2013-1-2',null)
insert into #customs_CustomsDeclaration ([BusinessNum],[AdvanceNum],[DeliveryListNum],[DeclareDate],[Declare_Name])
values('RPI201310000015','43545','34565','2013-1-5','reter')
insert into #customs_CustomsDeclaration ([BusinessNum],[AdvanceNum],[DeliveryListNum],[DeclareDate],[Declare_Name])
values ('RPI201310000016','123123','324324324','2013-2-1','ewrewr')
insert into #customs_CustomsDeclaration ([BusinessNum],[AdvanceNum],[DeliveryListNum],[DeclareDate],[Declare_Name])
values('BPO103942','4345','23432','2013-1-1','3432') 

insert into #customs_CustomsDeclaration ([BusinessNum],[AdvanceNum],[DeliveryListNum],[DeclareDate],[Declare_Name])
values('YLO201310001539','4345','23432','2013-1-1','3432') 

------------------------------------------------------------



;with ShenHeHZ_Flag
as
(
	select 
		BusinessNum,Flag_ManagerCheckCost,count(1) IsExists
	from #cost_FeeInfo
	group by BusinessNum,Flag_ManagerCheckCost
)
,ShenHeHZ_NoFlag
as
(
	select 
		BusinessNum,count(1) IsExists
	from #cost_FeeInfo
	group by BusinessNum
)
,ShenHeHZ_F
as
(
	select 
		a.BusinessNum,a.Flag_ManagerCheckCost,a.IsExists IsExists_Flag,b.IsExists IsExists_NoFlag
	from ShenHeHZ_Flag  a
		join ShenHeHZ_NoFlag b on a.BusinessNum=b.BusinessNum
)
,Result
as