Hi All
In the DataBase i Stored the Some information(represented in the Attached ScreenShot)

what is the best way to get the longest hierarchy id?
in the attached pic the longest hierarchy is 128 ,because it has the least number of 0's values in it's fields(t_definition_types_id_(1-4))

Thank You