Foros del web, para los que viven de bits

CREATE PROCEDURE SP_Cliente
	@Id_Cliente
begin 
DECLARE  C1 CURSOR FOR
	SELECT ID_Num_Fact
	FROM         Factura
	WHERE     
	ID_cli_Factura = @ ID_Cliente
OPEN C1 
FETCH NEXT FROM C1 
	into  @ ID_Num_Fact
WHILE @@FETCH_STATUS = 0
BEGIN     
           	Execute SP_Det_Factura @ID_Nun_Fact	
             FETCH NEXT FROM C1 
	     into  @ ID_Num_Fact
 END
 CLOSE C1
 DEALLOCATE C1
end
GO

CREATE PROCEDURE SP_Det_Factura
	@ID_Nun_Fact
begin 
Select sum(Det_Factura_valor)
From Det_Factura
Where ID_Num_Fact = @ID_Num_Factura
End

.....
DECLARE @mitotal INT OUTPUT
BEGIN     
           	Execute SP_Det_Factura @ID_Nun_Fact, @mitotal OUTPUT	
             FETCH NEXT FROM C1 
	     into  @ ID_Num_Fact
 END
.....

CREATE PROCEDURE SP_Det_Factura
	@ID_Nun_Fact,
	@total INT OUTPUT
begin 
Select @total= sum(Det_Factura_valor)
From Det_Factura
Where ID_Num_Fact = @ID_Num_Factura
End