tsql cte example

Example 1: CTE statement sql server

WITH Employee_CTE (EmployeeNumber, Title)
AS
(SELECT NationalIDNumber,
        JobTitle
 FROM   HumanResources.Employee)
SELECT EmployeeNumber,
       Title
FROM   Employee_CTE

Example 2: tsql cte in a transaction

BEGIN TRANSACTION

;WITH CTE .....
SELECT.....etc.

COMMIT TRANSACTION