Viewing 15 posts - 76 through 90 (of 1,246 total)
Nice work Jeff. I think my 2nd attempt is actually closer to your solution than the first. We both omitted the tally function/table and simply used the position list to parse...
August 15, 2020 at 8:00 pm
Deleted due to Jeff's delete. 😀
August 15, 2020 at 7:41 pm
Just for the fun of it, I decided to change it up so that will identify all of the position/character matches and tell you what the positions are and the...
August 15, 2020 at 7:14 pm
Thank you All!
Steve, apologies - I had no intention to offend you. I have looked into fnTally / the link you have kindly provided.
Much obliged.
Thank you for the...
August 15, 2020 at 2:20 pm
Heh... it's amazing how similar that is to the code I wrote (still holding out on that because I really am curious what the end game is for this...
August 15, 2020 at 1:54 pm
Take this for a spin...
DECLARE
@array_6 varchar(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie, yuppie, rabble, tallow, brooks, tassel, meddle, callus, peddle, sobbed, kneels, getter, brooms, dulled,...
August 15, 2020 at 3:46 am
All other things held equal, I'll take a desktop machine every time. The desktop will always win on price to performance. The added case space makes it easier to cool...
August 12, 2020 at 2:38 pm
No need for a followup... at least not one using STRING_SPLIT()... By the time you convert the split values to INTs and sort on them, the DelimitedSplit8k() version is way...
August 2, 2020 at 3:28 am
yes Jason. The string always in numerical ascending order. and every string will have exact 5 numbers in production.
In that case, here is a modified version of Jeff's test...
August 2, 2020 at 3:07 am
Quick question... In all of your example data, the array values appear to be in numerical order. Is this always the case or just a you creating fake test data?
Second...
August 2, 2020 at 1:36 am
Sounds like a good case for a bit of dynamic sql... The following will look at sys.sequences and, where the start_value is less than the ;ast_used_value, generate and ALTER SEQUENCE...
July 31, 2020 at 2:03 pm
If you want help that includes actual code, read this and do as it says.
July 31, 2020 at 4:32 am
I know it's an option in SQL Prompt... but... I do not think the inclusion/exclusion of quoted identifiers is a configurable scripting setting in SSMS.
July 30, 2020 at 5:47 pm
This solution is working like a charm. Thanks to all for your wonderfull suggestions. and ideas.
There were several solutions offered. Which one did you go with?
July 27, 2020 at 4:26 pm
Viewing 15 posts - 76 through 90 (of 1,246 total)