CTE’s or Common Table Expressions is a feature that is available since MS SQL Server 2005.
It’s a kind of temporary view or to translate it in NAV lingo, temporary tables. CTE’s only exist
in the query where they are declared and can be used as it was a regular table.