Advertisement
Guest User

Untitled

a guest
Feb 16th, 2020
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. select * from CONTACTPARAMETER where PARAMETERNAME='Email Action Alert / Press Releases'
  2. select * from CONTACTPARAMETERHIGHLIGHT where PARAMETERNAME='Dont Post Newsletters / Appeals'
  3. select * from FORMGRUDTCRITERIA where CRITERIA='Dont Post Newsletters / Appeals'
  4. select * from lookupvalue where LOOKUPVALUE1='Dont Post Newsletters / Appeals'
  5.  
  6. select * from FORMGRUDTCRITERIA where CRITERIA like 'EFY appeal%'
  7.  
  8.  
  9. delete from lookupvalue where lookupvalue1='EFY appeal / Xmas appeal Only' and id>24000
  10. delete from FORMGRUDTCRITERIA where id=16
  11.  
  12. update FORMGRUDTCRITERIA
  13. set CRITERIA=replace(criteria,' / ',' / ')
  14. from FORMGRUDTCRITERIA
  15. where CRITERIA like '% / %'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement