New Version of my color coding script (recursive this time)

#1 · 2025-01-14, 8:56 pm

I'm posting a new version of my color coding script. The previous version was four steps in four files. The second and third steps should have been recursive, but I wrote them as non-recursive and the user had to run them multiple times manually.

The second and third steps are rewritten to be recursive. And the four steps have been re-packaged into a single file. Otherwise, the functionality is the same as the previous version.

Uploaded files:

color_code_relatives_v3.sql

Tom Holden and kevync have reacted to this post.

#2 · 2025-01-15, 12:25 pm

Thanks for sharing -- I was actually considering looking at adapting my CTE script to do recursive but had not really played with recursive .

#3 · 2025-01-15, 1:25 pm

I failed to mention that the previous version updated PersonTable.Color9 which is color set #10. With the new version, I updated PersonTable.Color which is color set #1.

kevync has reacted to this post.