So, to be clear, the code specified above, inserting rows into #tmp would be analogous to what would be found in the EVENT_XREF table defined in the DDL.  The corresponding...

jcelko;

Thanks for your response.  I've attached the DDL of the pertinent tables.

In the interest of self preservation 🙂 it's worth noting the design, naming conventions etc. of the database I'm...

• This reply was modified 3 years, 6 months ago by  CanuckBuck.
• This reply was modified 3 years, 6 months ago by  CanuckBuck.
• This reply was modified 3 years, 6 months ago by  CanuckBuck.

I think I might have found a solution!

Connect to a Custom SQL Query - Tableau

I'll report back once I've tried this.

Frederico and Jonathan;

First.  Thank you for your support on this.  I really appreciate it.

Jonathan;  it took me a few hours to figure out what your code is doing.  The code...

Federico;

The result I need is actually in the submission ID column of Jonathan's solution.  SELECT DISTINCT [SUBMISSION_ID] FROM #tmp2

Jonathan;

My present solution approach, in Tableau, was predicated on joining primary data...

Jonathan;

As far as output I my mind has been focused on creating a complete list of all relationships for all nodes in the input data set.  However, I see that...

In discussing this requirement with the SMEs for the product I'm building and also delving into the details of what the information capture solution permits submitters to do in terms...

Frederico;

You are correct that ...if a user "searches" for submission id 1500 then 4, 5, 1000, 1100, 1200 should be returned as being related.  Knowing that 11oo is a child...

Jeff;

For any given scenario the starting node could be any one in a defined set.

My thought was to have a simple two-column table where every node is related to every...

Frederico;

I do need to find siblings.  In the scenarios I've illustrated above the code I've posted solves for scenarios 1 and 2.  If you run the code above with the...

Perhaps this diagram will help illustrate the situation.  In any of the given scenarios I need to find ALL related nodes given the ID of any node in the scenario.

frederico;

This is exactly what I was looking for!  And I've learned something new.  I didn't know about filtered indexes.  I had considered a unique index but dismissed because I didn't...

Phil;

Thanks for the response.  That is an option.  I was hoping to implement some kind of constraint at the database level that would be applied even if someone were doing...

Sergiy;

Thanks for sharing.  I confess that I'm not certain I understand the purpose of coding as you've described.  What problem does it solve? Is it a method of mitigating risks...

Jeffrey;

Thanks for the suggestion.  This is definitely a sound approach for the reasons you've noted.  The reason I've created it as I have is for the convenience/clarity of writing quick...

• This reply was modified 4 years, 1 month ago by  CanuckBuck.