Narasimhan Jayachandran

SQLServerCentral Article

Building Parent-Child Table Tree information

How many times have you wanted to know which child or grandchild records exists for a parent record? SSMS doesn't make this information easy to find beyond one level. New author Narasimhan Jayachandran brings us an article and a recursive solution.

3.31 (29)

You rated this post out of 5. Change rating


12,153 reads


Azure Workbooks


I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet


A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

SQL Server Quickie #46 – SQL Server on Linux


Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Read the latest Blogs


The World of Data Science

By urmila880

Comments posted to this topic are about the item The World of Data Science

PowerQuery in SSIS... is it only in 2023?

By pietlinden

First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...

Slicing status based on conditions

By MrRobot

Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers