cross-apply Examples and Free Source Code

SQL Unpivot Rolling Date/Week Calculation...

sql pivot azure-synapse unpivot cross-apply

CROSS APPLY OPENJSON on Dictionary<string, object[]>...

t-sql azure-synapse cross-apply open-json

Proper Set operation to find a matching set in a set of sets, or full join?...

sql sql-server join set cross-apply

Postgres analogue to CROSS APPLY in SQL Server...

sql postgresql postgresql-9.1 cross-apply lateral

CROSS/OUTER APPLY in MySQL...

mysql join subquery cross-apply

Is there a way to use CROSS APPLY from SQL to Spark SQL?...

databricks azure-databricks cross-join databricks-sql cross-apply

Using CROSS APPLY for more than one column...

sql-server-2008 t-sql ssms csv cross-apply

Why is CROSS APPLY resulting in one less row?...

sql sql-server cross-apply

Flatten and group a set of data using PIVOT twice...

sql sql-server pivot cross-apply

How can I update a table using the following CROSS APPLY?...

t-sql cross-apply

How can I implement Dijkstra's Algorithm in T-SQL to find the shortest route through my data-poi...

sql sql-server temp-tables cross-apply

Using STRING_SPLIT to normalize data in temp tables?...

sql split cross-apply

Cross apply vs CTE in Sql Server...

sql-server t-sql cross-apply

Conditional CROSS APPLY in SQL Server...

sql sql-server cross-apply

count values in json array per ID on multiple rows w/ OPENJSON...

sql json sql-server cross-apply open-json

How to use SQL Server openrowset and Cross Apply to get an XML Attribute...

sql-server xml t-sql xquery cross-apply

Using cross apply in update statement...

sql-server sql-server-2005 sql-update cross-apply

How to split more than one comma separated column as a separate row in SQL using CROSS APPLY...

sql sql-server select cross-apply

SQL Count each occurence of words separated by comma...

sql sql-server t-sql cross-apply

SQL Server - LEFT JOIN two JSON objects on a common property...

json sql-server left-join cross-apply

How to return all rows in a column when using cross apply and DelimitedSplit8K_LEAD together in SQL ...

case sql-server-2019 cross-apply

How to insert multiple JSON rows into a T-SQL table...

c#json t-sql cross-apply

Display Two columns at the same time using Cross Apply...

sql-server t-sql cross-apply

Transposing multiple related columns...

sql sql-server t-sql unpivot cross-apply

Using CTE instead of Cursor...

t-sql sql-server-2005 common-table-expression database-cursor cross-apply

SQL - How To Use "CROSS APPLY" In Query...

sql sql-server cross-apply

Count on CROSS APPLY with JSON Data...

json sql-server cross-apply

Why CROSS APPLY and INNER JOIN returns different result...

sql-server t-sql join cross-apply

How can I use Cross Apply to multiple rows?...

sql-server cross-apply

When should I use CROSS APPLY over INNER JOIN?...

sql sql-server performance t-sql cross-apply