Index: trunk/SQL/help_query/anulowanie_emisji.sql
===================================================================
--- trunk/SQL/help_query/anulowanie_emisji.sql (revision 1005)
+++ trunk/SQL/help_query/anulowanie_emisji.sql (revision 1005)
@@ -0,0 +1,10 @@
+DECLARE @reklama varchar(50);
+SET @reklama='TJAP005_07';
+
+SELECT * FROM reklama WHERE [id reklamy]=@reklama;
+
+SELECT * FROM [uka¿e siê w nr] WHERE reklamaid IN (SELECT ReklamaId FROM reklama WHERE [id reklamy]=@reklama)
+order by [Nr Wydania];
+
+update [uka¿e siê w nr] set status = 2, dataAnulowania = getdate()
+   where id in (2147773280, 2147773281, 2147773282, 2147773283);