Stairway to Advanced T-SQL Level 2: Using the APPLY Operator
May 6, 2015 · The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS …
Understanding and Using APPLY (Part 2) – SQLServerCentral
Mar 12, 2009 · The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.
Difference Between cross apply and cross join - SQLServerCentral
Jan 7, 2010 · CROSS APPLY WAS introduced in SQL Server 2005 ... For SQL 2000 CROSS JOINS exist and they exist in SQL 2005 as well ... so the difference is .. one exists one does not.
Using Cross Apply with WHERE clause - SQLServerCentral
Jan 15, 2019 · Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Using Cross Apply with WHERE clause Post reply
The many uses of CROSS APPLY – SQLServerCentral
Sep 3, 2009 · Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the first...
Parse Data from a Field Containing Multiple Values using CROSS APPLY
Aug 18, 2008 · 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.
How to call a stored proc once per each row of a table, without using ...
Jul 10, 2014 · How to call a stored proc once per each row of a table, without using CURSOR Forum – Learn more on SQLServerCentral
OPENJSON and CROSS APPLY – SQLServerCentral
Jun 9, 2020 · OPENJSON and CROSS APPLY Marty, 2020-06-24 (first published: 2020-06-09) OPENJSON is pretty central to manipulating JSON documents in T-SQL.
Splitting delimited values across multiple columns on same row.
Oct 11, 2023 · So using the custom string split scripts with a CROSS APPLY got it to work for me. Since the values in Pipe delimiter were fixed per type, I used the MAX (CASE ...) option which worked.
Using T-SQL to Transform XML Data to a Relational Format
Oct 29, 2014 · ); The T-SQL query to cross apply twice to build result set for populating BookCoAuthors is below: A few notes on the BookCoAuthors T-SQL query: The lines 18-21 in the above statement …