Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

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. 

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

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. 

Parse Data from a Field Containing Multiple Values using CROSS APPLY

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.

SQL Server CROSS APPLY and OUTER APPLY

Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.

CROSS APPLY on named sets

Find all actual words from Dictionary Table using jumbled word

How to get all actual word from a table,if I pass a jumbled word

Compatibility issue and CROSS APPLY

This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY