Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from CONTACTPARAMETER where PARAMETERNAME='Email Action Alert / Press Releases'
- select * from CONTACTPARAMETERHIGHLIGHT where PARAMETERNAME='Dont Post Newsletters / Appeals'
- select * from FORMGRUDTCRITERIA where CRITERIA='Dont Post Newsletters / Appeals'
- select * from lookupvalue where LOOKUPVALUE1='Dont Post Newsletters / Appeals'
- select * from FORMGRUDTCRITERIA where CRITERIA like 'EFY appeal%'
- delete from lookupvalue where lookupvalue1='EFY appeal / Xmas appeal Only' and id>24000
- delete from FORMGRUDTCRITERIA where id=16
- update FORMGRUDTCRITERIA
- set CRITERIA=replace(criteria,' / ',' / ')
- from FORMGRUDTCRITERIA
- where CRITERIA like '% / %'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement