;WITH T AS
    (
      SELECT MemberNo , ParentMemberNo,MemberName,AccountType,InDate,AuditDate
      FROM View_GetMember
      WHERE MemberNo = 'as4234426'
      UNION ALL
      SELECT A.MemberNo , A.ParentMemberNo,A.MemberName,A.AccountType,A.InDate,A.AuditDate
      FROM View_GetMember AS A  JOIN T AS B ON A.ParentMemberNo = B.MemberNo
    )
SELECT * FROM T 
消息 530，级别 16，状态 1，第 1 行
语句被终止。完成执行语句前已用完最大递归 100。