如何在sql server中生成分层数据的序列号

I have create a function in sql to get a serial number in hierarchy.I have table called Goals.the structure of table is belowI have create a function in sql to get a serial