Dimension SQL tool, is new SQL Query tool for TaskCentre, which will connect to and perform queries on any Microsoft SQL database.

The tool will run in 2 different modes:

• Direct Mode: The tool will perform ordinary queries, where some data is retrieved from a Microsoft SQL database to a TaskCentre recordset. The parameters to the query, is taken from any TaskCentre Variable or function.
• Lookup Mode: The tool will perform queries, which are used to expand TaskCentre recordsets with extra columns, extra records or both. In this mode, the tool will perform one query per record in the incoming recordset and will merge the original recordset with the result of the query. Parameters for the query are taken from the content of the incoming recordset as well as from standard TaskCentre variables and functions.

The tool features a graphical user interface, where you can set up your queries using drag and drop. The features supported during the graphical setup of the query include:

• Parameters
• Sub-queries and derived tables
• Grouping
• Aggregated functions such as Sum, Average, Standard Deviation and more
• Aliasing
• …and much more

You can also edit the query by hand, and the Graphical user interface will update to reflect your changes.

Parameters to the query are specified by standard TaskCentre drag and drop of variables, functions and recordset values.