create function aa(@upperid int)returns @t table (id int,upperid int,level int)asbegindeclare @i intset @i=1insert into @tselect *,@i from t where upperid=@upperidwhile @@rowcount>0beginset @i=@i+1insert into @tselect a.*,@i from t a left join @t b o

x��TQS�@�+�X4|�N�ʵ=䜚t����@��VDA�2 EZu�Ҩ��l��������y����~�~w���L�bT02[2r���4���Ef�<ᆘ��(Y�MtA�I�-��KV���βg�ȳ\�Z��<��L�j�)7lf��bb>�XN�G:�Z�"��à(�L�c~�#��[�|�,"3%1��:|wb�N����fynr#�%K��59�|��@ d��O2��aI�)�En�k���R!�}[� �� ��uJ�����Z6-�@�' ����7��bf���S>�^?X�����n�z�ާ*��_h��[o4h���4N`a�R���/�}�_^�3�U��j�[ ���Y�w� jh���jH�t�;;ג�x~h��Z-i��Qǐ��@�4x�E>w��:f���8�+^^��7�uG�%t�Ѫ�$ hl^/5�P[�|�#�W������j�~M�i�����N��T�J_M��u���n;���R��i�w�A���~���6.d-�pc�� 㻭��|q��)̨W�h���~�3�!2:S u~]^���X�:g�=�f��)�W-c��%�����-�S�|���:1�74k(t.u�:��{�E둅�Xn~"8�,��λ(����#�A
7��
�J�@og7!�jfu��2���"T�O�Ejd�Y���r