All Questions
3 questions
1
vote
1
answer
10k
views
SQL Query : Using JOINS with CASE Statement [closed]
I've 3 DE
MASTER DE with fields SubscriberKey(PK), donottrack, Createddate, Modifieddate
Staging DE with field CustomerID(PK), Createddate
Reference DE with field donottrack default value false.
...
- 71
1
vote
1
answer
1k
views
SQL query to get Open rate by domain
I'm trying to build an SQL query to get the Open Rate Percentage by domain for an email send through Journey build or scheduled send. Below is the query I have trying to figure out, but it's giving me ...
- 71
0
votes
2
answers
804
views
Checking for a non ascii character in SQL Query activity
I have certain records in my DE, where the first name contains '�'. I wish to extract such records. Obviously a like wouldn't work. Is there a way to do this in SQL Query Activity.
- 1,693