How to use CTE in SQL Server 2005 15

Common table expression acts as temporary result set for the query (select, insert , delete and update or merge). It can be use as derived table for storing result set and while joining with different tables. CTE doesnot act as object and scope is limited to till query execution.  Can be use as alternative option ...