Top "Cross-apply" questions

The T-SQL APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query.

When should I use cross apply over inner join?

What is the main purpose of using CROSS APPLY? I have read (vaguely, through posts on the Internet) that cross …

sql sql-server performance tsql cross-apply
CROSS APPLY with table valued function restriction performance

I have problem with CROSS APPLY with parametrised table valued function. Here is simplified pseudo code example: SELECT * FROM ( SELECT …

sql-server performance restriction cross-apply
CROSS/OUTER APPLY in MySQL

I need to use CROSS APPLY in MySQL (EC2 RDS MySQL instance). Looks like MySQL doesn't recognise the CROSS APPLY …

mysql join subquery cross-apply
Get the count of nodes in an XML field XQuery SQL Server 2008

I am trying to get the count of nodes in an XML field. but I always see 0 as the result. …

xml sql-server-2008 cross-apply
Postgres analogue to CROSS APPLY in SQL Server

I need to migrate SQL queries written for MS SQL Server 2005 to Postgres 9.1. What is the best way to substitute …

sql postgresql postgresql-9.1 cross-apply lateral
Using CROSS APPLY for more than one column

Day #3 with SQL Server. I am trying to combine 2 columns of delimited data into one output from a Table Valued …

sql-server-2008 tsql ssms delimited-text cross-apply
Using cross apply in update statement

Is it possible to use the cross apply clause in the from part of an update statement, in SQL Server 2005?

sql-server sql-server-2005 sql-update cross-apply
Cross Apply to get child parent value from Xml in SQL Server

I have the following XML: <root> <row value="US"> <col value="00">Jon</col&…

sql-server sql-server-2008 tsql cross-apply sqlxml
Entity Framework and CROSS/OUTER APPLY

I want to create some test cases for Entity Framework queries that surely generate SQL commands that contain CROSS APPLY …

sql sql-server entity-framework cross-apply outer-apply
cross apply xml query performs exponentially worse as xml document grows

What I Have I have a variable size XML document that needs to be parsed on MSSQL 2008 R2 that looks …

sql-server performance sql-server-2008-r2 sqlxml cross-apply