When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to add a derived table to a query, they should follow the next steps:
1. Open an existing query or create a new query.
2. Right-click the Diagram Pane and choose Add New Derived Table.
A new table with the name derivedtbl_N is added, and the derived table’s SELECT statement is added to the query’s FROM clause.