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.
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-applyI have problem with CROSS APPLY with parametrised table valued function. Here is simplified pseudo code example: SELECT * FROM ( SELECT …
sql-server performance restriction cross-applyI need to use CROSS APPLY in MySQL (EC2 RDS MySQL instance). Looks like MySQL doesn't recognise the CROSS APPLY …
mysql join subquery cross-applyI 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-applyI 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 lateralDay #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-applyIs 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-applyI have the following XML: <root> <row value="US"> <col value="00">Jon</col&…
sql-server sql-server-2008 tsql cross-apply sqlxmlI 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-applyWhat 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