Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE POV_cadPOV SET CFeId = NULL
- WHERE IdPOV IN (
- SELECT
- origem.IdPOV
- FROM POV_cadPOV origem
- WHERE origem.CFeId IN (SELECT cfeid FROM pov_cadpov GROUP BY cfeid HAVING COUNT(CFEid) > 1)
- AND
- origem.IdPOV <>
- (SELECT TOP 1 IdPOV FROM POV_cadPOV temp WHERE temp.CFeId = origem.CFeId ORDER BY DATA ASC)
- ) -- fecha in
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement