OUTER APPLY

SQL Server CROSS APPLY and OUTER APPLY

• by Additional Articles

• MSSQLTips.com

• cross apply

• Article

Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.

2016-02-17

7,571 reads

Departures from Origins and Arrivals at Destinations

• by Dwain Camps

• SQLServerCentral.com

• T-SQL

• Article

A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.78 (9)

Log in or register to rate

You rated this post out of 5. Change rating

2012-12-11

12,158 reads

• Discuss

Using T-SQL CROSS APPLY and OUTER APPLY

• by Additional Articles

• developer.com

• T-SQL

• Article

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.

2009-11-06

7,434 reads

RE: SQLServerCentral.com Is Moving

• by SQLBill

• MSSQLTips.com

• Reply

Best of luck. With the great job you've done with this site so far, the move should go smoothly. You've done all the proper steps...plan it, notifiy users (and family). Now you just have to do it. And if something unexpected should happen, that's part of the IT would and we'll bear with you (at […]

2004-09-17

RE: English Query Problem

• by Dinesh Asanka

• SQLServerCentral.com

• Reply

Thankx for the information

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-01-13

RE: UDF as Computed Column Part 2

• by currym

• developer.com

• Reply

Hmmmm... It was with the first script "Create Schema Authorization" but the entire exercise worked fine this morning. The fn_getDuration function is nice little headbanger. Thanks for your assistance.

2003-07-23