CREATE PROCEDURE SP_Calcul_Rendement
	(@NomTable 	  varchar(30),
	 @NomChamp	  varchar(30))
AS 

	DECLARE @Annee	 	smallint,
		@Mois		smallint,
		@Rendement	real,
		@Cumule 	real,
        	@Annuel 	real,
        	@Annualise 	real

	DECLARE ms_crs_1 CURSOR local static for 
			SELECT Annee, Mois, @NomChamp ,  
        			 @NomChamp + 'Cum ',
        			 @NomChamp + 'Ann ',
        			 @NomChamp + 'Annuel ' 
             		 FROM   @NomTable  
             		 WHERE   @NomChamp  <> 0  
             		 ORDER BY Annee, Mois
   
	open ms_crs_1
	fetch ms_crs_1 into @Annee,
			    @Mois,
			    @Rendement,
			    @Cumule,
        		    @Annualise,
        		    @Annuel

	while @@fetch_status >= 0
	begin

		-- index suivant
		fetch ms_crs_1 into @Annee,
				    @Mois,
				    @Rendement,
				    @Cumule,
	        		    @Annualise,
	        		    @Annuel

	end
	deallocate ms_crs_1

return (0) -- fin de SP_Calcul_Rendement