Viewing 15 posts - 1,381 through 1,395 (of 59,061 total)
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
I cannot give DDL and sample data. Only that small part pretty much that I gave in the first message and yes, you are correct, I need to write...
May 26, 2023 at 9:02 pm
@Eirikur,
I keep looking at your timing results. You say the following...
Given the performance improvements gained by removing one REVERSE instance, I think we got some opportunities for improvement and more...
May 26, 2023 at 3:38 am
Viewing 15 posts - 1,381 through 1,395 (of 59,061 total)