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

Content with tags T-SQL, cross apply Rss

   Items 1 to 4 of 4   
 

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 | 9,421 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,601 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,426 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,884 reads
   Items 1 to 4 of 4   
 
Tags
blogs (2)    
outer apply (2)    
pivot (1)