-
READ MORE
This may seem a weird question for those that are not familiar with SFMC SQL Query Activities because they do not realize the crazy amount of different ways you can use different functions to accomplish the same end result table segmentation. Now, just because the end result is identical, this does not mean that each […]
-
READ MORE
Have you ever run across a one to many relationship that you need to have listed fully in a single field? You are not in the minority. There are tons of places, especially is something like an MDM that requires this type of data storage. The issue is, how do you do this inside of […]
-
READ MORE
Many people do not realize that the SQL used in SFMC Query Activities follows Three-Valued Logic, which essentially means there are three possible outcomes for any Boolean value: True False Unknown(NULL) A value that is NULL therefore cannot be true or false. How is this relevant? Well, this causes issues with conditional statements in SQL […]
-
READ MORE
Retrieving delimited values from String in SQL utilizing XML and the Value() function.
-
READ MORE
This one took a LOT of digging and trial and error to figure out. Most of the normal SQL ways to accomplish this (like STRING_SPLIT, etc) are not supported in SFMC, making it heavily reliant on duct tape and bubblegum. Due to my recent exposure to the XML aspects of SQL, I thought that perhaps […]
-
READ MORE
This is a bit of a niche use case, but honestly, those are usually the ones that are the most powerful to know. Keep in mind this is for use in SFMC SQL Query Activities and is not optimized for use outside of this platform. Ok. So you have a specific naming convention for your […]