Using a temporary named result set that can be used within other statements, such as SELECT, INSERT, UPDATE and DELETE is called what? code example
Example: CTE statement sql server
WITH Employee_CTE (EmployeeNumber, Title)
AS
(SELECT NationalIDNumber,
JobTitle
FROM HumanResources.Employee)
SELECT EmployeeNumber,
Title
FROM Employee_CTE