SQL query upper-level stored procedures

------------------------ SQL query upper-level Stored Procedure ----------------------------

Create proc proc_treeUpQuery
@ Id varchar (20)
As
Declare @ count int
Declare @ SQL varchar (5000)
Declare @ temp varchar (2000)
Declare @ tempCount nvarchar (2000)
Set @ SQL = 'select superiorid from B _userlist where userid = '+ @ id
Set @ temp = 'select superiorid from B _userlist where userid = '+ @ id
While (1 = 1)
Begin
Set @ tempCount = 'select @ count = count (superiorid) from B _userlist where userid in ('+ @ temp + ')'
Exec sp_executesql @ tempCount, n' @ count int output', @ count output
If (@ count = 0)
Begin
Break
End
Else
Begin
Set @ temp = 'select superiorid from B _userlist where userid in ('+ @ temp + ')'
Set @ SQL = @ SQL + 'Union '+ @ temp
End
End
Exec (@ SQL)
Go

Exec proc_treeUpQuery '000000'