Practical Reporting Queries with CROSS APPLY (Part 3)

This article continues the series on APPLY, showcasing how some practical reports can be implemented using this operator.

CROSS APPLY Fundamentals: Part 1

Learn the basics of the CROSS APPLY operator with a few examples in this short piece.

Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY

Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.

How to Find the Start and End Dates for the Current Week (and more)

Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)

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