Hi all

I have a self-joined kind of table where iID is the PK and iPID is the parent records FK in the same table.

Now I am at a particular record and I want to know how deep this record is in the heirarchy. The reason is I don't want to allow changing of the iPID for the first and second level records as they are default records and should not be disturbed.

Thanks and regards.