Timeline for all the dependants of a stored procedure or function recursively - but shown only once
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 29, 2019 at 11:22 | vote | accept | Marcello Miorelli | ||
| Oct 29, 2019 at 11:13 | comment | added | Marcello Miorelli | Let us continue this discussion in chat. | |
| Oct 29, 2019 at 11:09 | comment | added | Scott Hodgin - Retired |
I updated my example. What if you simply alter the final where clause like this? WHERE rn_type = 1
|
|
| Oct 29, 2019 at 11:08 | history | edited | Scott Hodgin - Retired | CC BY-SA 4.0 |
Corrected demo code
|
| Oct 29, 2019 at 11:03 | comment | added | Marcello Miorelli | I knew this would be tricky - so I have now updated the result I get, using the link above. Basically it is duplicating some functions | |
| Oct 28, 2019 at 18:49 | history | edited | Scott Hodgin - Retired | CC BY-SA 4.0 |
Corrected demo code
|
| Oct 28, 2019 at 18:47 | comment | added | Scott Hodgin - Retired |
hmm - what happens if you change my partition by to be ROW_NUMBER() over (partition by depentent_type, depentent_name order by depth, row) as rn_type
|
|
| Oct 28, 2019 at 18:39 | comment | added | Marcello Miorelli | I think that if you had access to my data you would get it straight. The idea and the way of thinking deserves +1, thank you. the result I get is here | |
| Oct 28, 2019 at 18:30 | comment | added | Scott Hodgin - Retired | @MarcelloMiorelli - I'm not sure if my solution will work or not as I don't have access to your full range of data. Also, my example uses a different object_id than yours. | |
| Oct 28, 2019 at 18:28 | comment | added | Marcello Miorelli | ops, I have posted my answer without seen yours, surely I will have a look and let you know. | |
| Oct 28, 2019 at 18:25 | history | answered | Scott Hodgin - Retired | CC BY-SA 4.0 |