CTE 中用游标的方法

DECLARE @olnID int
DECLARE crx CURSOR LOCAL FAST_FORWARD FOR
WITH oln_tree  AS
(
select id from table_1
)
select id from oln_tree
OPEN crx
FETCH NEXT FROM crx INTO @olnID
WHILE @@FETCH_STATUS = 0
BEGIN
select @olnID
--call sp EXECUTE dbo.spBAS_delOrderLines @olnID = @olnID
FETCH NEXT FROM crx INTO @olnID
END
 
CLOSE crx
DEALLOCATE crx