Viewing 15 posts - 1 through 15 (of 227 total)
Doesn't this work only provided that the delimiter is a period?
Yep, you are correct. Thanks for adding this!
March 24, 2020 at 5:07 pm
I had a similar difficulty in explaining why I felt procs were preferable to EF. My initial reaction was very strongly in favor of procs over EF, although after calming...
March 6, 2020 at 8:38 am
The problem with this solution is that the UDF assumes the same order of rows as the substrings in the input string, while the documentation for string_split says the...
March 3, 2020 at 1:19 am
Thank you for the responses, and forgive any naivitee I may have on the matter; this was someone else burning firehose from which I was asked to drink.
September 4, 2019 at 6:39 pm
Thanks for the post! I just did the whole Microservices analysis thing too, and here's what I took away from it.We have a bunch of shared databases which are...
December 10, 2018 at 9:49 am
September 14, 2018 at 10:57 pm
Looks interesting, but the code is a bit of a jumble and doesn't seem to run without a lot of cajoling.
July 30, 2018 at 11:14 am
Thanks for the post. I thought fast_forward cursors were the exception to the rule of cursors being slow because it's only supposed to query the data once, and it only...
February 23, 2018 at 10:26 am
February 12, 2018 at 7:35 pm
January 23, 2018 at 7:25 pm
Hold that thought; I may have actually just written my statement wrong.
January 23, 2018 at 12:04 pm
Thanks so much for the post. Interestingly enough, the subject of using extended properties for documentation came up just last week at work. As with most new features I learn...
November 20, 2017 at 11:36 pm
Nice post. Now if someone could just figure out how to do this with procs that return multiple result sets...
September 22, 2017 at 10:45 am
June 27, 2017 at 3:34 pm
June 27, 2017 at 9:38 am