May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
Delete from lookuptablevalues ltv where ltv.keyvalue in ( select distinct(si.value_ci) collate Latin1_General_CI_AS keyvalue from recipientlists rl, recipientstringvalues rsv, rv_stringindex si, lookuptablevalues ltv, recipientdatevalues rdv where rsv.recipientid = rl.recipientid and rl.recipientid = rdv.recipientid and rsv.fieldid = 1462 and rl.listid=5773 and si.id = rsv.valueid and ltv.lookupid=193 and ltv.keyvalue = si.value_ci collate Latin1_General_CS_AS and rdv.value < getdate()-7 )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.