Some miscellaneous tips to help you get more from CR

Learn here...

Using the EXCEPT operator, new in SQL Server 2005

The linked article shows how you can use the new EXCEPT operator in SQL Server 2005 using an example. Click here to learn more...

Common Table Expressions in SQL Server 2005

Common Table Expressions, or CTE, are a new construct introduced in Microsoft SQL Server 2005 that offer a more readable form of the derived table that can be declared once and referenced multiple times in a query. Read more...