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: )

557 reads

Blogs

Daily Coping 28 Jun 2022

By

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

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Azure Pricing, SQL Server seems pretty high?

By keven11

Hi, I'm really new to this and I think I've got this wrong, wondering...

Linked Server only tables in catalog are available

By daniel.dolan

I have two servers, ServA and ServB. ServA is set up as a linked...

NOT and NULL

By kuopaz

I've been here before on this but have come across it again, so wanted...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers