Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Update top (100) DUMMYTABLE
- set ESTADO = 3
- where ESTADO = 5 order by FECHACREACION desc
- Update top (100) DUMMYTABLE
- set ESTADO = 3
- where ESTADO = 5 and id in (select top(100) * from DUMMYTABLE where ESTADO = 5 order by FECHACREACION desc)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement