Viewing 15 posts - 886 through 900 (of 1,391 total)
deleted
September 1, 2020 at 11:25 pm
Steve Collins- I didn't see a "function-ized" version of your code in the thread. If I missed it, point it out and I'll include it in another round of...
August 25, 2020 at 2:51 pm
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...
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...
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!
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)
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...
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...
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...
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?
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,...
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' ...
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
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...
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...
August 13, 2020 at 1:33 pm
Viewing 15 posts - 886 through 900 (of 1,391 total)