Recursive function in sql server 2005?

Question

Can programming examples illustrate recursive functions? For example, a Fibonacci series or factorial ..

Answer 1

Here are some articles I found using google.com;)

Recursion in T-SQL
Using recursion in stored procedures
Recursive User Function (SQL Server 2000)

Answer 2

Search for "common table expressions." See also this link.

Refresh Adding an example from the link above:

;WITH Fibonacci(n, f, f1) AS ( -- This is the anchor part -- Initialize level to 1 and set the first two values as per definition SELECT CAST(1 AS BIGINT), CAST(0 AS BIGINT), CAST(1 AS BIGINT) UNION ALL -- This is the recursive part -- Calculate the next Fibonacci value using the previous two values -- Shift column (place) for the sum in order to accomodate the previous -- value too because next iteration need them both SELECT n + 1, f + f1, f FROM Fibonacci -- Stop at iteration 93 because we than have reached maximum limit -- for BIGINT in Microsoft SQL Server WHERE n < 93 ) -- Now the easy presentation part SELECT n, f AS Number FROM Fibonacci 

Answer 3

For recursion of CTE requests see this link. http://www.4guysfromrolla.com/webtech/071906-1.shtml

For recursion of TSQL procedures / functions, see this link http://msdn.microsoft.com/en-us/library/aa175801%28SQL.80%29.aspx