Viewing 15 posts - 3,166 through 3,180 (of 59,067 total)
You need to fix the example you posted. You tried to obfuscate some information with a Magenta Marker but it was actually a hiliter and we can read the data...
July 13, 2022 at 3:43 pm
With the understanding that I've not done any deep analysis on any of the code posted and going only on what I've seen in the past, the nested REPLACEs that...
July 13, 2022 at 3:41 pm
Thanks for the feedback, Kazoo! I appreciate it.
July 13, 2022 at 3:07 pm
(Sigh...) My apologies, folks. I spent a couple of hours manually color coding all of the code because I knew the "code windows" on this site makes a bit of...
July 13, 2022 at 2:00 am
First things first... ALWAYS read the Microsoft Documentation on such things. Here's the link so there's no excuses on the prime duty of a DBA...
https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql
Second, look at the options......
July 12, 2022 at 9:01 pm
I checked the link in the response and got "Malicious Site Blocked" warning and so hit with the spam button. And, yea... I subscribed to the original post as soon...
July 12, 2022 at 7:47 pm
Great question, Steve.
Another hint here is that there's nothing to guarantee the order within any given rank.
July 11, 2022 at 10:54 pm
Can anyone think of any real life examples where you'd want to rank over something non-unique?
Heh... along with what the others posted, another possible answer is "Interview Question" 😉
July 11, 2022 at 10:53 pm
Ok... that's roughly the same query you've posted two other times. It's not nice to cross post. Stick with one thread on something like this.
July 10, 2022 at 6:26 pm
And why on Earth are you convert IDs to VARCHAR(MAX)?
July 10, 2022 at 6:24 pm
So is it a text or image file or a combination or??? What kind of file is it?
July 10, 2022 at 6:21 pm
Sorry for the confusion. Yes, as the data stands right now the entire column should be populated with an *. If the department column included 0001 and 0002, then...
July 10, 2022 at 6:19 pm
July 10, 2022 at 6:17 pm
Thanks for the feedback, Kenneth.
July 9, 2022 at 3:50 am
Guess how my f$%^ing Saturday has started too.
You mean you set your alarm on to go off on a Saturday morning 😀 😀 😀
I won't bore you with how...
July 9, 2022 at 3:47 am
Viewing 15 posts - 3,166 through 3,180 (of 59,067 total)