Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag cross apply Rss

   Items 1 to 8 of 8   
 

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 | 8,410 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 | 2,579 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,422 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 | 768 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 | 6,869 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,074 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 | 10,994 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,176 reads
   Items 1 to 8 of 8   
 
Tags
t-sql (4)    
blogs (3)    
outer apply (2)    
compatibility level (1)    
humor (1)    
pivot (1)    
split string (1)    
string manipulation (1)    
udf (1)    
xml (1)