Situation: We've integrated Salesforce's Marketing Cloud with an autodialer to aid in getting in touch with leads. The team's availability is variable, and the last thing we want is to blast too many calls, resulting in people just waiting in queue. So, I'm going to provide the team's manager with a web form where she can enter a number of leads to have the system call.
Problem: Marketing Cloud's SQL Activity does not support variables. So, while I'd like to do something like:
SELECT TOP @X lead.phone FROM lead WHERE lead.status = 'Open' ORDER BY lead.dateCreated DESC
This just can't be done.
My Question to You, Oh SQL Guru's: Is there another way that I can go about solving this problem?