Viewing 15 posts - 1,396 through 1,410 (of 59,065 total)
My Dad told me when I was quite young that "Half of all that is written is wrong and the other half is usually written in such a fashion that...
June 3, 2023 at 3:15 am
Lordy... such companies exist but, man, they're very rare. Most companies are like the one you speak of... they've adopted a horribly misshapen, grossly incorrect, interpretation of what "Agile" is...
June 2, 2023 at 5:37 pm
Since you're new, please see the article at the first link in my signature line below if you want tested code. For me, it's super rare for me to post...
June 2, 2023 at 2:03 am
That's a great idea, Jonathan. Unfortunately and as the OP revealed in the post at the link below, the reasons aren't quite that simple.
https://www.sqlservercentral.com/forums/topic/not-like-alternatives-in-where-clause#post-4200971
June 1, 2023 at 1:39 am
Isn't this a job for "Replication"? IIRC, it can even update the meta data in the target to match that in the source.
June 1, 2023 at 12:56 am
I'm not sure that I understand your question but, at face value, I have to say that "It Depends" on the privs you give "the business", whatever that is defined...
June 1, 2023 at 12:52 am
Thank you, Jeff.
Much appreciated.
I just remembered a bit of trick code using "Cascading CTEs" that I did about a million years ago for the exact opposite of what you're...
June 1, 2023 at 12:40 am
So can anyone say have they turned the old Model-T into a futuristic hover car or at least a hybrid?
No. But consider that the Model-T still does exactly what...
May 31, 2023 at 2:08 am
1. Only #temp or ##temp tables.
2. Yes
3. Sadly no.
Massive thanks.
Heh... they really don't want this to be fast, do they? 😉
Instead of TempDB, how about a very small database...
May 31, 2023 at 2:00 am
Thank you, Jeff. The real data will have various reasons, but I need to exclude only three out of the rest. I can confirm now the pipe (|) can...
May 30, 2023 at 11:41 pm
Very valid point. No, there is no separator, but after having an internal chat, it may be possible to add a pipe (|) as a separator.
That would help for...
May 30, 2023 at 9:07 pm
Do those reasons have a unique character that separates them? Your original post doesn't show one but I had to ask.
Ghads Jeff I know this is a quality...
May 30, 2023 at 9:05 pm
Thank you for the reply, yet I think it will not work if the reason column, as I mentioned in my original request, will have several concatenated reasons.
Do those...
May 30, 2023 at 6:33 pm
Just to be sure, a LOG or History or Audit or Temporal table should never have any triggers or constraints on it that evaluates data. Certainly, it should not be...
May 28, 2023 at 4:22 pm
Having supported a COBOL application for over 10 years, COBOL is a good language. Yes, it is wordy compared to modern programming languages, but that doesn't mean it...
May 28, 2023 at 4:15 pm
Viewing 15 posts - 1,396 through 1,410 (of 59,065 total)