sql server 语句

            1
            with
            temp
            2
            as
            3
            (

            4
            select a.*from[dbo].[erdos_tradepave] a join[dbo].[erdos_checkin] b on a.pk_checkin = b.pk_checkin
5where b.isback=‘N‘and b.isexchange =‘Y‘ )
67select*from[dbo].[erdos_tradepave] e where8[PK_TRADEPAVE]in (select c.[PK_TRADEPAVE]from[dbo].[erdos_tradepave] c leftjoin[dbo].[erdos_checkin] d on c.pk_checkin = d.pk_checkin

            with
            temp
            as
            
(

            select a.*from[dbo].[erdos_tradepave] a join[dbo].[erdos_checkin] b on a.pk_checkin = b.pk_checkin
where b.isback=‘N‘and b.isexchange =‘Y‘ ),

temp1
as
(
select*from[dbo].[erdos_tradepave] e where[PK_TRADEPAVE]in (select c.[PK_TRADEPAVE]from[dbo].[erdos_tradepave] c leftjoin[dbo].[erdos_checkin] d on c.pk_checkin = d.pk_checkin)

select*from temp1

            insert
            into
            [
            Accommodation
            ].[dbo].[CheckIn]([Cid],[OrderCode],[Name],[Sex],[IdCard],[PhoneNo],[FeeScaleCid],[Fee],[RoomCid],[CheckInDateTime])select a.[Cid],a.[VBILLNO],a.[NAME],1,a.[ID],isnull(a.[CONTACTTYPE],‘‘),b.[Cid],b.[FeeValue],c.[Cid],a.[INDATE]from[Erdos].[dbo].[erdos_checkin] a leftjoin[Accommodation].[dbo].[FeeScale] b on b.[FeeValue]=a.[ACCOMMODATIONCOST]leftjoin[Erdos].[dbo].[erdos_dormdoc] c on c.[PK_DORMDOC]=a.[PK_DORMDOC]where a.[DR]=0and b.[FeeType]=1and a.[NAME]isnotnull;

            update a set a.[Sex]=0from[Accommodation].[dbo].[CheckIn] a leftjoin[Erdos].[dbo].[erdos_checkin] b on b.Cid=a.Cid where b.[SEX]=1;

            update a set a.DormCategoryCid=ISNULL(c.Cid,‘D4CD56C7-E861-4EA4-886F-E4ED47BC73BF‘)
from[Erdos].[dbo].[erdos_dormclass] a leftjoin[Erdos].[dbo].[erdos_dormclass] b on b.PK_DORMCLASS=a.PK_DORMCLASSF leftjoin[Accommodation].[dbo].[DormCategory] c onCHARINDEX(c.CategoryName,b.DORMCLASSNAME)>0whereCHARINDEX(‘专家‘,a.DORMCLASSNAME)=0andCHARINDEX(‘女生‘,a.DORMCLASSNAME)=0andCHARINDEX(‘男生‘,a.DORMCLASSNAME)=0and a.ILEVEL=3and a.DR=0;

            insert
            into
             Accommodation.dbo.Change(Cid,checkincid,fee,PhoneNo,Reason,IdCard,GroupCid,IsCash,CashEndTime,Name
,CorpCid,DepartmentCid,RoomCid,Post,ChangeDateTime,Sex,groupname,corpname,department,
            [
            status
            ]
            )

            select
            NEWID(),b.cid,a.accommodationcost,a.contacttype,a.hpreason,a.id,a.industrial_group,case  a.ISXJFLAG when‘Y‘then1else0end ,a.jfenddate,a.NAME
,a.pk_corp,a.pk_deptdoc,c.cid,a.pk_om_job,a.TPDATE,a.SEX,d.CHARGEDEPTNAME,d.UNITNAME,e.deptname,a.[Status]from dbo.erdos_tradepave a leftjoin dbo.erdos_checkin b on 
a.pk_tradepave=b.pk_tradepave leftjoin dbo.erdos_dormdoc c on a.pk_dormdocnew=c.PK_DORMDOC
leftjoin dbo.bd_corp d on a.pk_corp = d.pk_corp 
leftjoin[dbo].[bd_deptdoc] e on a.pk_deptdoc=e.pk_deptdoc
 where a.DR=0and b.Cid isnotnulland a.NAME isnotnull ;