Common Table Expression

Creates a sort of temp table within a view.

The CTE only exists while the view is being queried.

CREATE OR ALTER VIEW SchemaName.vwViewName
AS
WITH MyCteName AS (
	SELECT *
	FROM SchameName.TableName)
SELECT * FROM MyCteName