Viewing 15 posts - 916 through 930 (of 1,419 total)
Suppose there were tables which pre-split the words so there's an established correct baseline for comparisons. Also there could be a script with nested loops that executes different procedures dynamically...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 18, 2020 at 12:38 pm
The 1,000 names in the test variables vary in length from 2 to 11 characters. Here's some code to generate 8 random tests and store them in a UDT. I...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 18, 2020 at 11:54 am
It's a half eaten pretzel balanced on top of 2 rolls of toilet paper. Not the worst ERD I've seen!
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 18, 2020 at 11:27 am
This link takes you to a page that lists the top 1000 most popular baby names.
Here are 5 groups of 50 names (of variable lengths) declared as NVARCHAR(MAX)
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2020 at 1:36 pm
Ok here's contender #1. This one doesn't split the six and five letter input strings into separate words. It splits it straight into letters and finds the commas and bases...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 15, 2020 at 5:37 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 kind...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 15, 2020 at 1:57 pm
Thank you, Steve
Sadly none of your examples works for me from the Studio - getting various error messages.
The code probably worked just fine for Steve. When you get...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 15, 2020 at 12:12 pm
Maybe you do not have an fnTally function? If so that's easily remedied. Have a look at this thread. What are the specific messages?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 14, 2020 at 10:12 pm
Here's for six letters. It returns Bertha. To do for five letters would follow a similar pattern.
DECLARE @six_letters NVARCHAR(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie,...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 14, 2020 at 9:37 pm
DECLARE @six_letters NVARCHAR(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie, yuppie, rabble, tallow, brooks, tassel, meddle, callus, peddle, sobbed, kneels, getter, brooms, dulled, maggot, webbed' ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 14, 2020 at 2:52 pm
Maybe have a look at this other thread where something similar was discussed.
https://www.sqlservercentral.com/forums/topic/ignoring-error-and-continue/page/2/#post-3765149
Not the connecting using openrowset but the loop and the error and continue
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 13, 2020 at 3:47 pm
For the road I have a small-form-factor laptop that fits nicely on an airline tray table.
That's what I should've done. My Asus laptop with a 17" screen weighs like...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 13, 2020 at 3:33 pm
You should write an article on it and submit it.
...I'll submit something.
Since this was written I've been on this trying to make it happen. Wow, 3 months ago...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 13, 2020 at 1:33 pm
What I dislike about PIVOT is that you have to repeat UNIONs several times depending on the metric. This makes it difficult to change and error-prone as you may...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 12, 2020 at 2:06 pm
Frank's answer above removes the reference to the CODE_CHARGECREDIT table and removes c.PEOPLE_ORG_ID (which is non-existent) from the GROUP BY. Idk if that makes sense. Fixing the (many) errors and...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 11, 2020 at 12:00 pm
Viewing 15 posts - 916 through 930 (of 1,419 total)