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

558 reads

Blogs

Daily Coping 8 Dec 2022

By

Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.

By

One of my favorite parts of having a new job is that I learn...

Daily Coping 7 Dec 2022

By

Today’s coping tip is to stop for a minute when you walk outside and...

Read the latest Blogs

Forums

Problem Importing NULLs in varchar field

By John524

hello, This is something I'm really struggling with and haven't found much when I...

SQL Server 2022 is RTM

By Grant Fritchey

You can get your hands on SQL Server 2022 right now and this forum,...

Blocking

By sqlguru

We were getting constant blocking on the db server. However, after stopping the process...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers