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.
2023-11-24
Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.
2023-11-24
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)
2022-07-13
31,763 reads
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: 2019-11-24)
752 reads
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: 2019-11-08)
2,038 reads
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.
2019-06-07 (first published: 2017-10-30)
13,050 reads
Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.
2016-02-17
7,571 reads
2016-01-13
1,488 reads
How to get all actual word from a table,if I pass a jumbled word
2012-09-27 (first published: 2012-09-05)
824 reads
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
5,942 reads
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Abobus Abobus Casino offers a vibrant and entertaining online gaming experience for players of...
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers