Appendix D: SQL Server Reference

The SQL statement is the principal element in a report that defines which data the report gathers and returns as the result set or multiple result sets. This appendix provides detailed information about the common SQL query statements and the query design tools found in SQL Server that will help you to write effective SQL statements.

SQL Query Statements

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 2000 and SQL Server 2005 to create or modify queries in SMS reports.