Update table won't update

• betsy.powlen

  SSC Enthusiast

  Points: 111

  More actions

  January 20, 2009 at 11:31 pm

  #72413

  Hi, I posted in the wrong forum earlier. I can't get my update table to update. I know its reading from the EPool table (which is empty), but I can't figure out the right way to do it. Thanks for any assistance!

  UPDATE dbo.EPool

  SET dbo.EPool.UIC = dbo.NAVMC.UIC

  ,dbo.EPool.TAM5 = dbo.NAVMC.TAM5

  ,dbo.EPool.NAVMCPO = dbo.NAVMC.PO

  ,dbo.EPool.OPFORTETotal = dbo.OPFORTE.OrgQTY

  ,PO_Over = CASE WHEN

  (dbo.NAVMC.PO > dbo.OPFORTE.OrgQTY) THEN dbo.NAVMC.PO -

  dbo.OPFORTE.OrgQTY ELSE '0' END

  ,PO_Under = CASE WHEN

  (dbo.NAVMC.PO < dbo.OPFORTE.OrgQTY) THEN dbo.OPFORTE.OrgQTY -

  dbo.NAVMC.PO ELSE '0' END

  FROM dbo.OPFORTE RIGHT JOIN (dbo.NAVMC RIGHT JOIN tblUnit_Ref ON dbo.NAVMC.UIC = tblUnit_Ref.UIC) ON dbo.OPFORTE.MEFUIC = tblUnit_Ref.MEFUIC, dbo.EPool

  WHERE (((dbo.tblUnit_Ref.DET)= 0) AND ((dbo.NAVMC.TAM5) Like '[A-E]%' And (dbo.NAVMC.TAM5) = dbo.OPFORTE_.TAM5))

• ps.

  One Orange Chip

  Points: 29255

  More actions

  January 20, 2009 at 11:33 pm

  #930117

  Pls post your replies to http://qa.sqlservercentral.com/Forums/Topic640431-338-1.aspx?Update=1

  ---

  
  Pradeep Singh