Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag cross apply Rss

   Items 1 to 11 of 11   
 

SQL Server CROSS APPLY and OUTER APPLY

Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.  Read more...
By Additional Articles 2016/02/17 | Source: MSSQLTips.com | Category: cross apply
Rating:  Rate this |   Briefcase | 6,468 reads

CROSS APPLY on named sets

By M Martin 2016/01/13 | Category: cross apply
Rating: (not yet rated) |  Discuss |   Briefcase | 1,374 reads

Cross Apply

By Adrian D 2015/10/15 | Category: apply
Rating: (not yet rated) |  Discuss |   Briefcase | 1,652 reads

The many uses of CROSS APPLY

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the first...  Read more...
By Kenneth Fisher 2013/05/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 15,044 reads

UNPIVOT a table using CROSS APPLY

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...  Read more...
By Kenneth Fisher 2013/04/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,193 reads

Departures from Origins and Arrivals at Destinations

A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.  Read more...
By Dwain Camps 2012/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,521 reads

Find all actual words from Dictionary Table using jumbled word

How to get all actual word from a table,if I pass a jumbled word  Read more...
By Ajeet Singh 2012/09/27 | Source: SQLServerCentral.com | Category: cross apply
Rating: |  Discuss |   Briefcase | 786 reads

Using T-SQL CROSS APPLY and OUTER APPLY

That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.  Read more...
By Additional Articles 2009/11/06 | Source: developer.com | Category: t-sql
Rating:  Rate this |   Briefcase | 7,081 reads

Compatibility issue and CROSS APPLY

This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY  Read more...
By Divya Agrawal 2009/08/06 | Source: SQLServerCentral.com | Category: cross apply
Rating: |  Discuss |   Briefcase | 5,110 reads

Split string using XML

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...
By Divya Agrawal 2009/06/25 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 11,205 reads

Accessing results in a random order: Towards the automated Thank-you letter

Phil shows how 'CROSS APPLY' can be useful for writing thank-you letters or thinking of excuses as to why your project has failed....  Read more...
By Phil Factor 2009/03/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,356 reads
   Items 1 to 11 of 11   
 
Tags
t-sql (5)    
blogs (3)    
outer apply (3)    
apply (1)    
compatibility level (1)    
humor (1)    
pivot (1)    
split string (1)    
string manipulation (1)    
top (1)    
top n (1)    
udf (1)    
xml (1)