StackOverflow Questions for Tag: outer-apply

Ed Avis

Reputation: 1552

Allow query planner to eliminate a left join even when not joining on a unique key

sql-serverjoinsql-execution-planouter-apply

Score: 2

Answers: 1

Happiness

Reputation: 21

How to transpose rows in a table to columns (using outer apply, dynamic query )?

.netsql-servertransposeouter-apply

Score: 0

Answers: 1

Brian Heward

Reputation: 556

SQL slow outer apply trying to read from 2 sharded tables

sqlsql-serverquery-optimizationouter-joinouter-apply

Score: 0

Answers: 1

TripleCute

Reputation: 83

Using Outer Apply to Compare 2 columns of one table that match values with 1 column in a different table

sqlcaseapplyouter-apply

Score: 0

Answers: 1

Joseph Shirk

Reputation: 55

DISTINCT results of CTE Outer Apply return empty set

distinctsql-server-2014outer-apply

Score: 0

Answers: 0

Qëndrim Izairi

Reputation: 27

Im trying to use DISTINCT and ORDER BY DESC with OUTER APPLY (2 tables), cannot get DESC order

sqlouter-apply

Score: -2

Answers: 1

Sean Werkema

Reputation: 6145

How can I union values across multiple columns of a result set without repeated table scans in the query plan?

sql-servert-sqlsql-execution-planunion-allouter-apply

Score: 0

Answers: 2

codingIsCool

Reputation: 72

Convert costly OUTER APPLY to LEFT JOIN

sql-servert-sqlquery-optimizationouter-apply

Score: 0

Answers: 0

Abbas Ali

Reputation: 1

Looping down a list of names and extracting data frame from a list of data frames

rlistlapplysapplyouter-apply

Score: 0

Answers: 0

Sunil Jadhav

Reputation: 71

How can I use with inside apply in sql server? I know another solution without apply. but can we do with outer apply? if 'yes' then how?

sql-serverxmlopenrowsetouter-applywith-clause

Score: 0

Answers: 1

Jason Daniel

Reputation: 11

SQL: How to resolve varchar numeric conversion using OUTER APPLY and SELECT TOP (1)?

sqlsql-servernumericvarcharouter-apply

Score: 1

Answers: 1

Pauli du Plooy

Reputation: 21

Is it possible to do a outer apply on two tables from different database engines to get unmatched records?

sql-serverleft-joinouter-applydatabase-engine

Score: 0

Answers: 0

aquawhale

Reputation: 11

Oracle Create Materialized View With Outer Apply Throws "missing right parenthesis" Error

sqloracle-databaseora-00907outer-apply

Score: 0

Answers: 1

Cătălin Rădoi

Reputation: 1894

Replace OUTER APPLY

sqlsql-serverquery-plannerouter-apply

Score: 0

Answers: 1

Elie Antoun

Reputation: 3

I have a syntax error in my Outer Apply statement, I can't understand why

google-bigqueryouter-apply

Score: 0

Answers: 1

TProgram

Reputation: 5

distinct result by entire table when using cross apply on json and order by with case

sql-serversql-order-bycasedistinctouter-apply

Score: 0

Answers: 1

suraj

Reputation: 11

Alternate way for outer apply in SQL Server

mysqlsql-serverouter-apply

Score: 0

Answers: 2

Leonardo Daga

Reputation: 155

Using .NET Core nested LINQ instruction in migration from SQL Server to MySQL

mysqllinqef-core-3.1outer-apply

Score: 1

Answers: 1

DeuceyPoo's Dad

Reputation: 61

T-SQL to LINQ to SQL using Navigation Properties

c#linqlinq-to-sqlleft-joinouter-apply

Score: 3

Answers: 1

learning coding

Reputation: 3

Get the latest entry time using SQL if your result returns two different time, should I use cross or outer apply?

sqldatediffcross-applyouter-apply

Score: 0

Answers: 2

PreviousPage 1Next

StackOverflow Questions for Tag: outer-apply

Allow query planner to eliminate a left join even when not joining on a unique key

How to transpose rows in a table to columns (using outer apply, dynamic query )?

SQL slow outer apply trying to read from 2 sharded tables

Using Outer Apply to Compare 2 columns of one table that match values with 1 column in a different table

DISTINCT results of CTE Outer Apply return empty set

Im trying to use DISTINCT and ORDER BY DESC with OUTER APPLY (2 tables), cannot get DESC order

How can I union values across multiple columns of a result set without repeated table scans in the query plan?

Convert costly OUTER APPLY to LEFT JOIN

Looping down a list of names and extracting data frame from a list of data frames

How can I use with inside apply in sql server? I know another solution without apply. but can we do with outer apply? if &#39;yes&#39; then how?

SQL: How to resolve varchar numeric conversion using OUTER APPLY and SELECT TOP (1)?

Is it possible to do a outer apply on two tables from different database engines to get unmatched records?

Oracle Create Materialized View With Outer Apply Throws &quot;missing right parenthesis&quot; Error

Replace OUTER APPLY

I have a syntax error in my Outer Apply statement, I can&#39;t understand why

distinct result by entire table when using cross apply on json and order by with case

Alternate way for outer apply in SQL Server

Using .NET Core nested LINQ instruction in migration from SQL Server to MySQL

T-SQL to LINQ to SQL using Navigation Properties

Get the latest entry time using SQL if your result returns two different time, should I use cross or outer apply?

How can I use with inside apply in sql server? I know another solution without apply. but can we do with outer apply? if 'yes' then how?

Oracle Create Materialized View With Outer Apply Throws "missing right parenthesis" Error

I have a syntax error in my Outer Apply statement, I can't understand why