cross apply

SQLServerCentral Article

4.9 (10)

2022-07-13

8,828 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. 

2019-11-25 (first published: )

530 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. 

2019-11-12 (first published: )

1,645 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)

2019-06-07 (first published: )

12,084 reads

Blogs

Why i use a smaller docker image part I

By

What is Docker? Docker is a famous platform for building, shipping, and running container...

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

Read the latest Blogs

Forums

SSIS Installation Issues

By mjdemaris

Hello all, I am attempting to install the SSIS package into VS2019 CE.  I've...

SQL blocking caused by running ALTER VIEW script

By webrunner

Hello experts, One of our developers tried to alter a view and reported to...

script to find the frequent used login information in the sql

By pols

Hi, Kindly some one share the script or query to get the login information...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers