无法绑定多部分标识符SIV_DB_PreProd.dbo.SIV_SuperVision.ReservationSabilId。

Question

我对这个错误有很大的麻烦。我试图从一个select的结果中插入一个表，并且我有一个我不明白的错误。

    INSERT INTO SIV_DB_PreProd.dbo.SIV_SuperVision  
        SELECT 

        HRC.ID_Reservation [ReservationSabilId]
        ,null [ConfigurationPlaceId]
        ,HRC.NUMERO_PLACE [NumeroPlace]
        ,HRC.NUMERO_COMPARTIMENT [NumeroCompartiment]
        ,HRC.CODE_TRAIN_AUTOCAR [NumeroCirculation]
        ,HRC.DATE_TRAIN [DateCirculation]
        ,(case HRC.CODE_CONFORT when 1 then 1 when 2 then 2 end) [CodeConfort]
        ,DATE_ETAT [DateReservation]
        ,1 [IsSabilToSIV]
        ,0 [StatutSuperVision]  


      FROM [dbo].RESERVATION_PLACE_CENTRAL HRC inner join HISTORIQUE_RESERVATION_CENTRAL
      on hrc.ID_RESERVATION= HISTORIQUE_RESERVATION_CENTRAL.ID_RESERVATION
      where  DATEDIFF(MM, DATE_ETAT , getdate())=0
      and hrc.NUMERO_EMETTEUR>0 and hrc.ETAT_RESERVATION in (''R'')
      and ( hrc.ID_RESERVATION <> SIV_DB_PreProd.dbo.SIV_SuperVision.ReservationSabilId 
            or (hrc.ID_RESERVATION = SIV_DB_PreProd.dbo.SIV_SuperVision.ReservationSabilId
                and SIV_DB_PreProd.dbo.SIV_SuperVision.StatutSuperVision = 0)
          )

Answer 1

插入SIV_DB_PreProd.dbo.SIV_SuperVision

     SELECT 

    HRC.ID_Reservation [ReservationSabilId]
    ,null [ConfigurationPlaceId]
    ,HRC.NUMERO_PLACE [NumeroPlace]
    ,HRC.NUMERO_COMPARTIMENT [NumeroCompartiment]
    ,HRC.CODE_TRAIN_AUTOCAR [NumeroCirculation]
    ,HRC.DATE_TRAIN [DateCirculation]
    ,(case HRC.CODE_CONFORT when 1 then 1 when 2 then 2 end) [CodeConfort]
    ,DATE_ETAT [DateReservation]
    ,1 [IsSabilToSIV]
    ,0 [StatutSuperVision]  


  FROM [dbo].RESERVATION_PLACE_CENTRAL HRC 

  inner join HISTORIQUE_RESERVATION_CENTRAL
  on hrc.ID_RESERVATION= HISTORIQUE_RESERVATION_CENTRAL.ID_RESERVATION

  inner join SIV_DB_PreProd.dbo.SIV_SuperVision SV
    on hrc.ID_RESERVATION=SV.ReservationSabilId

     where  DATEDIFF(MM, DATE_ETAT , getdate())=0
    and hrc.NUMERO_EMETTEUR>0 and hrc.ETAT_RESERVATION in (''R'')
     and ( hrc.ID_RESERVATION <> SIV_DB_PreProd.dbo.SIV_SuperVision.ReservationSabilId 
        or (hrc.ID_RESERVATION = SIV_DB_PreProd.dbo.SIV_SuperVision.ReservationSabilId
            and SIV_DB_PreProd.dbo.SIV_SuperVision.StatutSuperVision = 0)
      )

Answer 2

您正在尝试使用SIV_DB_PreProd.dbo.SIV_SuperVision表而不对其进行连接。如果我正确地理解了您的查询目的，您最好选择合并。

INSERT INTO SIV_DB_PreProd.dbo.SIV_SuperVision  
        SELECT 

        HRC.ID_Reservation [ReservationSabilId]
        ,null [ConfigurationPlaceId]
        ,HRC.NUMERO_PLACE [NumeroPlace]
        ,HRC.NUMERO_COMPARTIMENT [NumeroCompartiment]
        ,HRC.CODE_TRAIN_AUTOCAR [NumeroCirculation]
        ,HRC.DATE_TRAIN [DateCirculation]
        ,(case HRC.CODE_CONFORT when 1 then 1 when 2 then 2 end) [CodeConfort]
        ,DATE_ETAT [DateReservation]
        ,1 [IsSabilToSIV]
        ,0 [StatutSuperVision]  


      FROM [dbo].RESERVATION_PLACE_CENTRAL HRC inner join HISTORIQUE_RESERVATION_CENTRAL
      on hrc.ID_RESERVATION= HISTORIQUE_RESERVATION_CENTRAL.ID_RESERVATION
      INNER JOIN SIV_DB_PreProd.dbo.SIV_SuperVision SIV ON SIV.ReservationSabilId <> hrc.ID_RESERVATION or (hrc.ID_RESERVATION = SIV.ReservationSabilId
                and SIV.StatutSuperVision = 0)
      where  DATEDIFF(MM, DATE_ETAT , getdate())=0
      and hrc.NUMERO_EMETTEUR>0 and hrc.ETAT_RESERVATION in (''R'')