Index: trunk/SQL/StoredProcedures/sp_adMotoRaportProwizja.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_adMotoRaportProwizja.txt (revision 352)
+++ trunk/SQL/StoredProcedures/sp_adMotoRaportProwizja.txt (revision 355)
@@ -1,22 +1,15 @@
--- =============================================
--- Create basic stored procedure template
--- =============================================
 
--- Drop stored procedure if it already exists
-IF EXISTS (
-  SELECT * 
-    FROM INFORMATION_SCHEMA.ROUTINES 
-   WHERE SPECIFIC_SCHEMA = N'dbo'
-     AND SPECIFIC_NAME = N'sp_adMotoRaportProwizja' 
-)
-   DROP PROCEDURE dbo.sp_adMotoRaportProwizja
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
 GO
 
-CREATE PROCEDURE dbo.sp_adMotoRaportProwizja
+ALTER PROCEDURE [dbo].[sp_adMotoRaportProwizja]
 	@rok int,
 	@miesiac int,
-	@tytul nvarchar(100)
+	@tytul nvarchar(100),
+	@prowizjaPoz money,
+    @prowizjaKat money
 AS
-
 DECLARE @Wplywy TABLE
 (
@@ -60,4 +53,19 @@
 AND (Tytul IN (@tytul))
 
+IF @prowizjaPoz IS NOT NULL
+BEGIN
+UPDATE @Wplywy
+SET Prowizja=ROUND(NETTO * @prowizjaPoz, 2)
+WHERE Agencja='GS O/POZNAÑ'
+END
+
+IF @prowizjaKat IS NOT NULL
+BEGIN
+UPDATE @Wplywy
+SET Prowizja=ROUND(NETTO * @prowizjaKat, 2)
+WHERE Agencja='GS O/KATOWICE'
+END
+
+
 UPDATE @Wplywy
 SET Netto = NULL
@@ -86,11 +94,9 @@
 WHERE IdFaktury NOT IN (SELECT IdFaktury FROM @Wplywy)
 ORDER BY DataWplaty, Agent, NumerFaktury
-
-	
 GO
 
--- =============================================
--- Example to execute the stored procedure
--- =============================================
-EXECUTE dbo.sp_adMotoRaportProwizja 2009, 1, 'adMot'
+SET ANSI_NULLS OFF
 GO
+SET QUOTED_IDENTIFIER OFF
+GO
+