-
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
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 […]