视图递归 我头几天写了 和你的差不多
WITH locs(sbiID, sbiParentID, loclevel)
AS
(
SELECT sbiID, sbiParentID, 0 AS loclevel FROM SystemBaseInfo
WHERE sbiID IN ('+@sbiIDList+')
UNION ALL
SELECT a.sbiID, a.sbiParentID, loclevel + 1 FROM SystemBaseInfo a
INNER JOIN locs b ON a.sbiParentID = b.sbiID
)
这是我写的那个 你可以改下 需求都是一样的