Viewing 15 posts - 901 through 915 (of 1,402 total)
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
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...
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...
August 11, 2020 at 12:00 pm
Horses for courses and everybody thinks their way is the best. Why not have a sense of humor about it? I agree Pivot and Unpivot are kludge compared to conditional...
August 10, 2020 at 7:20 pm
Here's a simple CASE, what wouldn't this take embedded IIFs?
Idk why don't you give it a try and let us know
... since I write SQL now not a...
August 10, 2020 at 2:59 pm
Viewing 15 posts - 901 through 915 (of 1,402 total)