I’m not sure if the title above is understandable. What I mean by that is, you have a string and you want to split it and put each string element into specific columns. The split element is separated by a delimiter.
When you see the example below, I hope you understand what I’m trying to do (spoiler alert: it has something to do with CROSS APPLY).
If you are like me, you may have heard Azure a few years ago for the first time. You may even have tested and tried to work with it. But somehow, either you’ve been turned off by the cost (it starts reasonably small, but it can have snow ball effect if you are not careful) or the demands were not really out there. So you decided to stop using the service because you’d better use your time for something else.
However, cloud computing is the thing now, and it makes sense to give it another look.
Sometimes you want to have a copy of an existing database on […]
I originally wrote this article in December 2019 for my old blog. […]