The SQL statement is the principal element in a Configuration Manager 2007 report that defines which data the report gathers and returns as the result set or multiple result sets. The topics in this section provide detailed information about the common functions and joins used in SQL statements and about using the query design tools found in SQL Server to help you to easily write effective SQL statements.

In This Section

SQL Statement Reference

Provides detailed information and examples for using aggregate functions, joins, and the keyword phrase NOT IN.
Query Design Tools

Provides information about using the query design tools found in SQL Server 2005 to create or modify queries in Configuration Manager reports.
How to Create or Modify a Report SQL Statement Using Query Designer

Provides a step-by-step procedures to create or modify a report SQL statement using Query Designer in SQL Server 2005.