SQL Queries - Revision history

Peder at 18:16, 7 March 2016

2016-03-07T18:16:44Z

Peder at 18:16, 7 March 2016

2016-03-07T18:16:12Z

Peder at 18:13, 7 March 2016

2016-03-07T18:13:11Z

2010-06-18T07:15:27Z

Created page with 'Category:Result Variables If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Serve�?�'

New page

← Older revision		Revision as of 18:16, 7 March 2016
Line 1:		Line 1:
		+	[[Category:Reference Manual]]
	If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Server Management Studio. The results consists of several tables that must be joined. Below is one example of a query that creates a list of stand-level treatments for a selected optimization. To run this script, open SQL Server Management Studio, connect to the database server, and right-click "My_Heureka_Results" (or corresponding). Choose "New Query", paste the script below and click on "Execute". To see what value to use in the condition for "OPTIMIZATION.OptimizationNo" and "SIMULATION.SimNo", open the tables dbo.Optimization and dbo.Simulation, respectively, and look for the correct result sets.		If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Server Management Studio. The results consists of several tables that must be joined. Below is one example of a query that creates a list of stand-level treatments for a selected optimization. To run this script, open SQL Server Management Studio, connect to the database server, and right-click "My_Heureka_Results" (or corresponding). Choose "New Query", paste the script below and click on "Execute". To see what value to use in the condition for "OPTIMIZATION.OptimizationNo" and "SIMULATION.SimNo", open the tables dbo.Optimization and dbo.Simulation, respectively, and look for the correct result sets.

← Older revision		Revision as of 18:16, 7 March 2016
Line 1:		Line 1:
−	~~[[Category:Result Variables]]~~
	If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Server Management Studio. The results consists of several tables that must be joined. Below is one example of a query that creates a list of stand-level treatments for a selected optimization. To run this script, open SQL Server Management Studio, connect to the database server, and right-click "My_Heureka_Results" (or corresponding). Choose "New Query", paste the script below and click on "Execute". To see what value to use in the condition for "OPTIMIZATION.OptimizationNo" and "SIMULATION.SimNo", open the tables dbo.Optimization and dbo.Simulation, respectively, and look for the correct result sets.		If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Server Management Studio. The results consists of several tables that must be joined. Below is one example of a query that creates a list of stand-level treatments for a selected optimization. To run this script, open SQL Server Management Studio, connect to the database server, and right-click "My_Heureka_Results" (or corresponding). Choose "New Query", paste the script below and click on "Execute". To see what value to use in the condition for "OPTIMIZATION.OptimizationNo" and "SIMULATION.SimNo", open the tables dbo.Optimization and dbo.Simulation, respectively, and look for the correct result sets.

@@ Line 1: / Line 1: @@
-[[Category:Results]]
+[[Category:Result Variables]]
 If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Server Management Studio. The results consists of several tables that must be joined. Below is one example of a query that creates a list of stand-level treatments for a selected optimization. To run this script, open SQL Server Management Studio, connect to the database server, and right-click "My_Heureka_Results" (or corresponding). Choose "New Query", paste the script below and click on "Execute". To see what value to use in the condition for "OPTIMIZATION.OptimizationNo" and "SIMULATION.SimNo", open the tables dbo.Optimization and dbo.Simulation, respectively, and look for the correct result sets.
@@ Line 5: / Line 5: @@
 SELECT     SIMULATION.SimNo, TREATMENTUNIT.Description, TREATMENTUNIT.Area AS AvdProdArea,
-                       TREATMENTUNIT.Area * OPTIMIZATIONRESULT.Proportion AS , RESULT.AlternativeNo, RESULT_TREATMENTDATA.RowNo AS ,
+                       TREATMENTUNIT.Area * OPTIMIZATIONRESULT.Proportion AS Åtgärdsareal, RESULT.AlternativeNo, RESULT_TREATMENTDATA.RowNo AS ÅtgärdsNr,
-                       RESULT.Period, RESULT_TREATMENTDATA.Year AS , TREATMENTTYPE.Description AS ,
+                       RESULT.Period, RESULT_TREATMENTDATA.Year AS År, TREATMENTTYPE.Description AS Åtgärd,
                        RESULT_FORESTDATA.MeanAgeTotal_Before AS Medelålder, RESULT_TREATMENTDATA.VolumeCutTotal AS VolAvv,
                        RESULT_VALUEDATA.Net AS Netto, OPTIMIZATIONRESULT.Proportion AS Andel, OPTIMIZATION.OptimizationNo