I bet y’all thought that we had completely exhausted the topic of how to use APPLY – whether it be CROSS APPLY or OUTER APPLY. Well, guess what? Nope. Just nope. The word to remember when using either of the APPLY operators is deterministic. A deterministic function, as defined by O’Reilly, “always returns the same…… Continue reading Something to Remember with APPLY
Month: August 2021
CROSS vs OUTER: Knockdown drag-out free for all
In this corner, with a total of 10 letters – we have CROSS APPLY. In the other corner, also with a total of 10 letters – we have OUTER APPLY. Yes, that’s right. From the outside, there’s truly not a lot of difference between the two apply operators. Both of them work very well with…… Continue reading CROSS vs OUTER: Knockdown drag-out free for all
STRING_SPLIT is to be used with what?
My friends! Last time together, we discussed using the STRING_SPLIT function and how it’s used in combination with the CROSS APPLY. First off, most of us are used to working with an INNER JOIN instead of CROSS APPLY. Well, you’re not going to be able to use an INNER JOIN when you’re using the STRING_SPLIT…… Continue reading STRING_SPLIT is to be used with what?
Have Separated Fields? Make Them Rows!
Sometimes, you’ll have a lot of comma-separated data in your databases. Maybe you’ll have lots of data shoved into one field separated only by a vertical bar. As we all should be asking, “How do I get that data out of that one field and separated into several rows?” Well, I’m glad you asked, my…… Continue reading Have Separated Fields? Make Them Rows!
Opposite of a Left Anti Join
If you followed along with last weeks’ post (found here), then the title of today’s post hopefully makes sense. If not, then I would highly recommend reading it (or re-reading it) so that we all can be on the same page. Read it? Great. Let’s get started. Last week I left you with the following…… Continue reading Opposite of a Left Anti Join