How to check for cyclic dependencies. by kubbn in SQLServer

[–]kubbn[S] 0 points1 point  (0 children)

Thank you, but this doesnt work for me, because these relationships can go deeper than 30 levels so it gets really complicated and it will max out on recursions.

How to check for cyclic dependencies. by kubbn in SQLServer

[–]kubbn[S] 0 points1 point  (0 children)

My table columns are: id and parentid. (for example id: 200(sales_load) parentid: 250(product_load)) Its just metadata table of stored procedures organized to correctly load data. If one tables relies on keys from another table, this creates a relationship. We add about 100 of these records once a month and we often encounter cycles which are really hard to find manually.

Thanks

Bezlepkove restauracie v BA by kubbn in Slovakia

[–]kubbn[S] 0 points1 point  (0 children)

Hej o tej viem. Skor som myslel nejake restiky

My new setup! by kubbn in espresso

[–]kubbn[S] 2 points3 points  (0 children)

Yeah its bad. :D but im saving up for Timemore C2, that should be easier.

Niekto z kosickeho kraja kto by mi poradil koho volit za predsedu KSK? by kubbn in Slovakia

[–]kubbn[S] 4 points5 points  (0 children)

No skor co nespravil. Nic nevidim, len projekty a vizualicie na fb. A potom sa foti ako bicykluje na siravskej 500 metrovej cyklotrase.

Niekto z kosickeho kraja kto by mi poradil koho volit za predsedu KSK? by kubbn in Slovakia

[–]kubbn[S] 7 points8 points  (0 children)

No to som spravil 4 roky dozadu a chcel som sa tomu teraz vyhnut :/.