How to create recursive query in SQL Server?

Correct Answer: Recursive query can be create in SQL using stored procedure but you can also use CTE (Common table expression) It might be also worth asking about performance as CTE is not always very fast