Viewing 15 posts - 76 through 90 (of 1,244 total)
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
It sounds like you've already identified the cause of the problem. For any given "manage guid" every Detail row is related to every Payment row.
You have to determine if this...
July 27, 2020 at 2:34 pm
Viewing 15 posts - 76 through 90 (of 1,244 total)