UPDATE IT
  SET   
   IT.RetailStock=BS.RetailStock
   ,IT.RemainOrderQuantity=BS.RemainOrderQuantity
   ,IT.AllocateQuantity=BS.AllocateQuantity
   ,IT.SaleOneQuantity=BS.SaleOneQuantity
   ,IT.BranchAdjustQuantity=BS.BranchAdjustQuantity
   ,IT.ProdName=PT.ProdName
   ,IT.vardesc1=SPS.vardesc1
   ,IT.vardesc2=SPS.vardesc2
   ,IT.purchunits=PRS.purchunits
   ,IT.RetailPrice=PRS.RetailPrice
   ,IT.minorder=PRS.minorder
   ,IT.SusprRason=PRS.SusprRason
   ,IT.supplier=SU.supplier
   ,IT.[name]=SU.[name]
   ,IT.CatCode=TN.CatCode
  FROM  #IN_TABLE_S IT
  INNER JOIN sql_live.dbo.productcodes SPS with(nolock)
  ON IT.PROD_CD=SPS.variantcode
  INNER JOIN sql_live.dbo.products PT with(nolock)
  ON SPS.prodint = PT.prodint
  INNER JOIN
   (SELECT
    BCH.branchcode,CS.coverint
   FROM
    sql_live.dbo.branches BCH with(nolock)
   INNER JOIN sql_live.dbo.coverages CS with(nolock)
   ON 
    BCH.levint =CS.levint
   and              
    CS.typecode=1
   WHERE EXISTS
    (SELECT 1 FROM #Branch BR
    WHERE BCH.branchcode =BR.BranchCD)
    ) CS
  ON CS.branchcode=IT.BRANCHCode
  INNER JOIN sql_live.dbo.PRSourcePrefs PRS with(nolock)
  ON CS.coverint = PRS.plint
  AND PRS.varint = SPS.varint
  INNER JOIN EOB.dbo.CAOBuMonCatcode  TN with(nolock)
  ON PT.level2 = TN.BuMonCD
  LEFT JOIN 
   #BranchStocks BS
  ON IT.branchcode=BS.BRANCHCode
  AND IT.PROD_CD=BS.ProductCode
  LEFT JOIN sql_live.dbo.suppliers SU with(nolock)
  ON PRS.supplier = SU.supplier
  WHERE
   EXISTS 
    (SELECT 1 FROM #Branch BR
    WHERE IT.branchcode =BR.BranchCD)
   '+@Conn_CatCode_SUP)

请大家帮我优化一下上面的update操作，谢谢！