Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 

2110 Results Found

ARTICLE

Recursive Queries in SQL Server 2005

Recursive Queries Having seen the basic syntax of a CTE ... us turn to the more interesting use: Recursive Queries. A recursive query is one in which a CTE references itself. What is the use of a recursive query? Well, all of us SQL Server ... represent the same in a relational database and run queries against it. In SQL Server 2000, there was no inherent way to perform hierarchical queries and people had different implementations. You ...

ARTICLE

Recursive Queries in SQL:1999 and SQL Server 2005

... time in his life, had experience with recursion. When I was young, I was on leave ... having a concrete view of what is the infinite. That is it : recursion... A process which is able to reproduce himself ... situations, we do not accept infinite recursion. In the real world, we must have ...

ARTICLE

Exploring Recursive CTEs by Example

... experience than me for my fascination with recursive CTEs, I have nonetheless continued ... out there to guide the beginner. For those of us that are recursively challenged, the Books On Line description of the process ... SQL guru regurgitating the same hierarchies in their blogs, without adding any additional value ...

ARTICLE

Get month names ordered using recursion

... name alphabetically, as shown below. Both the queries I have written for these scenarios need ... last I found a way to write a query using a recursive common table expression (CTE). This in-line query will pull the month numbers by adding the month number + 1 recursively upto 12. Then it converts the month number ... datename function explicitly. The result of the above query: I suggest you create this query as a view to use it for any other SQL scripts in joins. You can also create ...

ARTICLE

Using Recursion and Date Tables to Simplify Date Logic

... date-related SQL. Combining this technique with a recursive query and the built-in date functions offers a lot ... design decisions, and show some sample queries. The Calendar Table The first table is a variation ... my current client to improve a slow query. There are several options for implementing your date ...

ARTICLE

Using a Recursive CTE to Generate a List

... lists of values per group in aggregate queries; passing a comma-delimited list of values ... Let's look at how this is achieved using recursive CTEs.  Overview of Recursive CTEs  A recursive CTE requires at least one UNION ALL operator. The simplest recursive form has one UNION ALL and two queries[1]: The anchor query is executed exactly once and the result is united with the results from the recursive member, which is executed until it returns ... You have to provide a condition that will ensure the recursive member query does not run indefinitely. The easiest way ...

ARTICLE

Creating Folders Using VB and Recursion

One of the many nice features of the scripting file system object (scrun.dll) is the create ... useful once you get the hang of it - recursion! Any time you're processing a tree ... etc), you're probably going to need a recursive solution. Recursion isn't the easiest thing to learn or to explain ...

ARTICLE

Finding the Next Business Day Recursively

A recursive function for calculating next business day ... day including taking into account holidays. A recursive function turned out to be just the thing ... Modulo function. I'll show you the scripts first and then go into the details. Scripts To start with, you'll need to create a table ...

ARTICLE

Reporting on Hierarchical Recursive data using Reporting Services

... which we also call commonly as Recursive data.  I am trying to shed ... some light on reporting of data which is recursive in nature in this article. What is Recursive Data? I am sure you ... come face to face with this challenge called Recursive Data if you have had to deal ...

ARTICLE

Reporting a menu structure using a recursive UDF

... any number of levels and as such is ideally suited to a recursive function to provide the necessary output (up to the recursion limit of your version of SQL). The next ... sliced and diced as required. In order to make the recursion work and provide the required output, I ... substring(Menustring,3,1024) The process in detail The nature of a recursive UDF is to repeat, calling itself and building ...