How can i get the id of the last child record in hierarchical data

SELECT t.*
FROM Table_3 t
WHERE NOT EXISTS 
(
SELECT 1
FROM dbo.Table_3
WHERE ParentID = t.ID
)

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page