I love to write about digital things, snoop around in code and learn about new technologies. If you have a suggestion for me, consider emailing me or filling out the contact form below. If you have questions about anything digital or need some help – reach out, or email me at william@yourdigitalaid.com
Joins, joins, joins – nothing but joins! Four tables that need to be joined together and uniquely filtered for specific things. Really think about how you want to structure your joins as if you’re joining. While this was not as hard as occupations, it’s easier... Continue Reading
A great question with the need to do multiple joins or pivot the data. Don’t overthink this one as it can get messy if you decide to try to do PIVOT or GROUP(CONCATENATE). What I learned from this problem is, you can Google or ChatGPT... Continue Reading
Another interesting query, with very unique criteria that you need to pay attention to. There’s multiple was you can attack this, but the most common way seems to be creation of a CTE, VIEW or function and using ROW_NUMBER(), PARTITION() to help number and organize... Continue Reading
YourDigitalAid is a collection of all things digital, real world and whatever else I wanted to write about. I’m a product-person by day and a scrappy digital-technepreneur by night. As you probably know, everything here is an anecdote, but being a good data driven individual, I will try to back up everything I do with results.
If you happen to need agile, product, digital marketing or process management support, shoot me an email, fill out a contact form or comment in one of my many posts / articles for help, guidance and support.
