Technical Article

An old and new way to query Hierarchical data

This script uses an old mathematical way of doing hierarchical queries. The most common way of showing hierarchical data in SQL Server is by creating a stored procedure that calls itself. This is not a recent problem, in fact this programming technique has been around since the first programming languages. By using stacks, you can […]

1 (1)

2007-05-02 (first published: )

556 reads

Blogs

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Getting a list of the articles in a publication.

By

The other day I was asked to supply a list of all of the...

Daily Coping 17 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL FileStream - Concurrency support

By balaece25

Hi team, We have already enabled a SQL filestream for storing API request and...

SQL FileStream - Concurrency support

By balaece25

Hi team, We have already enabled a SQL filestream for storing API request and...

AG Availability mode changed from Asyn to Synchronous

By SQL_Hunt

Hello Is there any good query available to find when the AG mode is...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers