Latest ads
-
Pure VPN - Up to 27 Months- vgp
- Updated:
-
Gemini AI PRO 18 months Offer- Hawaka
- Updated:
-
koko account
- DasunEranga
- Updated:
Algorithm Help - Database Referral
- Thread starter MihiCherub
- Start date
1. Table eke data tika data set ekakata ganna
2. Loop ekakin eka ID ekakin patan aran, A001 ahuwenakam serach karanna, a athare ahuwena ID array ekakata daganna
3. Array eken ganna puluwanne Userla tika
OR DB witharak nam
===========================
;WITH #results AS
(
SELECT id,
parentid
FROM
WHERE id = @childId
UNION ALL
SELECT t.id,
t.parentid
FROM
t
INNER JOIN #results r ON r.parentid = t.id
)
SELECT *
FROM #results;
==========================
http://stackoverflow.com/questions/11598827/recursively-find-all-ancestors-given-the-child
2. Loop ekakin eka ID ekakin patan aran, A001 ahuwenakam serach karanna, a athare ahuwena ID array ekakata daganna
3. Array eken ganna puluwanne Userla tika
OR DB witharak nam
===========================
;WITH #results AS
(
SELECT id,
parentid
FROM
WHERE id = @childId
UNION ALL
SELECT t.id,
t.parentid
FROM
INNER JOIN #results r ON r.parentid = t.id
)
SELECT *
FROM #results;
==========================
http://stackoverflow.com/questions/11598827/recursively-find-all-ancestors-given-the-child
Last edited:
