Why should you use CTE rather than simple views, in MS SQL Server?

Answer 1

With CTE you can use a recursive query with CTE itself. That’s not possible with views.