cross apply

SQLServerCentral Article

4.9 (10)

You rated this post out of 5. Change rating

2022-07-13

31,763 reads

Technical Article

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

  • Script

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

You rated this post out of 5. Change rating

2019-11-25 (first published: )

752 reads

Technical Article

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

  • Script

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

You rated this post out of 5. Change rating

2019-11-12 (first published: )

2,038 reads

SQLServerCentral Article

Parse Data from a Field Containing Multiple Values using CROSS APPLY

  • Article

It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.

3.27 (15)

You rated this post out of 5. Change rating

2019-06-07 (first published: )

13,050 reads

Blogs

Monday Monitor Tips: Searching Permission Changes

By

During a demo of Redgate Monitor Enterprise to a customer, they asked about how...

SQL Bits 2025 Wrap

By

SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...

Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed

By

As data becomes the backbone of modern business, understanding how to manage and analyze...

Read the latest Blogs

Forums

Abobus

By teamcounter2008

Abobus Abobus Casino offers a vibrant and entertaining online gaming experience for players of...

SQL Server 2008 to SQL Server 2022

By Skybvi

Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

Visit the forum

Question of the Day

Using Heaps

When does Microsoft recommend using a heap as a table structure (no clustered index)?

See possible answers