Advertisement
adeilsoncs

Corrigir erro UNIQUE na CFEID da POV_cadPOV

Apr 27th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.39 KB | None | 0 0
  1.  
  2. UPDATE POV_cadPOV SET CFeId = NULL
  3.  
  4.             WHERE IdPOV IN (
  5.  
  6.                             SELECT
  7.  
  8.                             origem.IdPOV
  9.  
  10.                             FROM POV_cadPOV origem
  11.                             WHERE origem.CFeId IN (SELECT cfeid FROM pov_cadpov GROUP BY cfeid HAVING COUNT(CFEid) > 1)
  12.                             AND
  13.  
  14.                             origem.IdPOV <>
  15.  
  16.                             (SELECT TOP 1 IdPOV FROM POV_cadPOV temp WHERE temp.CFeId = origem.CFeId ORDER BY DATA ASC)
  17.  
  18.                             ) -- fecha in
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement