sqlserver存储过程递归,寻找叶子

2024年5月28日发(作者：)

IF @isLastLeaf2=1

BEGIN

insert into costbom_z3 (ixkitl, ixitm, ixlitm, ixaitm,csum, csqty, cpuom, ixum, ixuom )

values(@OrignItem, @s_itm, @s_litm, @s_atim , @s_uom , @s_qty*@ParentQty, @p_uom, @s_Oum, @P_Ouom);

END

FETCH NEXT FROM mycur2

INTO @p_item, @p_uom , @s_itm, @s_litm, @s_atim , @s_uom , @s_qty, @p_Ouom, @s_Oum;

END

END

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[Factorial_ap](@Number Int,@RetVal Int OUTPUT)AS

begin

DECLARE @In Int

DECLARE @Out Int

IF @Number <> 1 BEGIN

set @In = @Number-1

EXEC Factorial_ap @In, @Out OUTPUT

SELECT @RetVal = @Number * @Out

END

ELSE BEGIN

SELECT @RetVal = 1

END

print @RetVal

RETURN

end

-- exec dbo.[Factorial_ap] 5,''

CLOSE mycur2;

DEALLOCATE mycur2;

END