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);
Index: trunk/RaportySQL.sln
===================================================================
--- trunk/RaportySQL.sln (revision 1005)
+++ trunk/RaportySQL.sln (revision 1005)
@@ -0,0 +1,26 @@
+
+Microsoft Visual Studio Solution File, Format Version 9.00
+# Visual Studio 2005
+Project("{F14B399A-7131-4C87-9E4B-1186C45EF12D}") = "RaportySQL", "RaportySQL\RaportySQL.rptproj", "{A4C1513E-6608-4812-A204-E385FA6C0199}"
+EndProject
+Global
+	GlobalSection(SolutionConfigurationPlatforms) = preSolution
+		Debug|Default = Debug|Default
+		DebugLocal|Default = DebugLocal|Default
+		Production|Default = Production|Default
+	EndGlobalSection
+	GlobalSection(ProjectConfigurationPlatforms) = postSolution
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.Debug|Default.ActiveCfg = Debug
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.Debug|Default.Build.0 = DebugLocal
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.Debug|Default.Deploy.0 = DebugLocal
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.DebugLocal|Default.ActiveCfg = DebugLocal
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.DebugLocal|Default.Build.0 = DebugLocal
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.DebugLocal|Default.Deploy.0 = DebugLocal
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.Production|Default.ActiveCfg = Production
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.Production|Default.Build.0 = Production
+		{A4C1513E-6608-4812-A204-E385FA6C0199}.Production|Default.Deploy.0 = Production
+	EndGlobalSection
+	GlobalSection(SolutionProperties) = preSolution
+		HideSolutionNode = FALSE
+	EndGlobalSection
+EndGlobal