Searching for "recursive"

Q:

How to create recursive query in SQL Server?

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.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL