Viewing 15 posts - 4,216 through 4,230 (of 59,067 total)
I finally had a decent bit of time to start working on this and went back through all of the comments to refresh my memory. I first came across this...
December 11, 2021 at 11:24 pm
I think we may be on the right track but my data isn't presenting correctly. I'm getting (although the seconds are not visible, they are incorrect): December 11, 2021 at 9:52 pm
Thanks for taking the time to write this article, Kathi.
What's even worse than what you mention is that the quality of the "official" documentation has totally tanked as is frequently...
December 11, 2021 at 9:23 pm
I have another question, I have data with space before square brackets and after sqaure brackets when i run below example 1 statement returning NULL. But in example 2...
December 10, 2021 at 9:48 pm
why do other uses need to see who can login on a server? that is on its own a security risk and should not be exposed by...
December 10, 2021 at 6:22 pm
Scott's method is the method I'd use to extract the object name.
I do concern myself what the source of the name is an how it will be used later in...
December 10, 2021 at 5:23 pm
why do other uses need to see who can login on a server? that is on its own a security risk and should not be exposed by default.
If it...
December 10, 2021 at 5:16 pm
Thanks for your hint! I used a calendar table and DENSE_RANK() as shown in the article to solve my problem. I appreciate your help very much.
To help others that...
December 10, 2021 at 5:14 pm
Total SWAG on my part but NOT using parentheses for the "N" number is only allowed for SELECTs and they did that only for backward compatibility. The correct syntax is...
December 10, 2021 at 3:10 pm
Thanks for sharing, I am very impressed with your post.
Smell that? {sniff}... smells like a prelude to SPAM.
December 10, 2021 at 2:45 pm
If you missed that about CONCAT_WS, you may have missed another fantastic enhancement they came out with 2017. The TRIM function. Most people give it the "yawn" because they think...
December 8, 2021 at 9:17 pm
Thanks for your feedback on what you've done. Can you provide expanded test data to demonstrate what you've done?
And, you've not avoided any joins like you said you wanted to...
December 8, 2021 at 8:31 pm
Hello SSC,
I hope everyone is staying safe and healthy.
I am using SQL 2017 and I have over 17 million rows that I have to UPDATE. Obviously I have to...
December 8, 2021 at 8:26 pm
I wound up in a highly similar position implementing 'immediate fixes' and never able to get to long-term solutions to stop all the 'immediate fixes.' It forced me into...
December 8, 2021 at 8:15 pm
Viewing 15 posts - 4,216 through 4,230 (of 59,067 total)