Viewing 15 posts - 1 through 15 (of 67 total)
Thank you Alan.
As noted above, I've attached the article in PDF format (no ads) to improve the layout of the tables.
R Glen Cooper
September 7, 2021 at 3:50 pm
A copy of this article is attached in PDF format, along with the resource section.
R Glen Cooper
September 6, 2021 at 1:49 am
Congratulations skeleton567 on your seniority in programming! Have you worked on mainframes?
In my opinion there are two basic skills needed in programming SQL (or any other language): mechanical and engineering.
The...
R Glen Cooper
August 19, 2021 at 5:26 pm
You can avoid MERGE in some cases:
https://qa.sqlservercentral.com/articles/how-to-avoid-merge-in-sql-server
R Glen Cooper
January 26, 2021 at 4:57 pm
"No one will drive us from the paradise which Cantor created for us"
David Hilbert
1925
Cantor's work in set theory was a stunning development, but so was mathematical logic.
Did you know that...
R Glen Cooper
January 19, 2021 at 5:00 pm
Nice article.
R Glen Cooper
April 23, 2020 at 4:59 pm
Thanks for the snippet to store MERGE counts.
The script is only meant to replace MERGE where you don't have special processing on any column (such as logging a row if...
R Glen Cooper
April 16, 2020 at 9:44 pm
You've raised a good point about Foreign Keys.
The script assumes no constraints on the target table, other than a key.
Basically, I extracted all the records into a no-constraint table and...
R Glen Cooper
April 16, 2020 at 4:03 pm
It looks like a random string "exddasf" got inserted into the script when I pasted it into the article:
-- Display Source and Target tables.
SELECT * FROM [dbo].[Table1] -- Source
SELECT *...
R Glen Cooper
April 15, 2020 at 7:49 pm
I wrote this script because MERGE seemed overkill for something quite simple. Also, as previous comments have indicated, this script has some advantages but it can't replace the more flexible...
R Glen Cooper
April 15, 2020 at 6:55 pm
Performance wasn't the motivator for this script because both approaches have performed well enough for me. But if you just want to know the status of each merged record (inserted,...
R Glen Cooper
April 15, 2020 at 4:56 pm
By "using mathematics" I meant "proving a new mathematical theorem or quoting on old one".
I had to prove a theorem to write this script.
I'm wondering aloud how a functionally equivalent...
R Glen Cooper
March 12, 2020 at 11:52 am
A SQL Server solution to this problem, without using mathematics, would be very interesting. This was a real problem that I worked on, and I expected to do some fancy...
R Glen Cooper
March 12, 2020 at 3:02 am
Thank you Jeff for a more elegant computation of fnBasic.
R Glen Cooper
March 10, 2020 at 4:40 pm
You are absolutely right.
The main point to this article is that the definition of basic sets paved the way for an algebraic solution, which surprised me.
R Glen Cooper
March 10, 2020 at 1:44 pm
Viewing 15 posts - 1 through 15 (of 67 total)