Posted inDynamics NAV & BC Tips & tricks
Common Table Expressions in MS SQL Server
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…