THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

APPLY – not exactly set-based

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at:

Published Tuesday, January 10, 2012 11:06 AM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Matt Velic said:

Hey, thanks for picking up my topic again! This is all really fantastic stuff you've been sharing about APPLY.

January 10, 2012 8:24 AM

Cody said:

Haha, yeah. I'm pretty sure a few months ago I refactored a statement using an APPLY/RANK combination and found out the same thing as you at the end :-) Many a keyboard thumping was had that day!

January 14, 2012 7:26 PM

Alfred Yom Tov said:

Simple enough, - APPLY is not a statement of the ISO ANSI SQL language standard. What's not standard  better not be used.

January 15, 2012 5:46 PM

mycall said:

Would another solution be chaining multiple CTEs together?

January 15, 2012 6:57 PM

ccc said:">">">

March 12, 2018 8:18 PM

aaaa said:

April 1, 2018 5:23 PM

chenyingying said:


May 6, 2018 11:05 PM

linying123 said:


May 10, 2018 8:10 PM

shenyuhang said:


June 1, 2018 7:06 PM

jake said:

June 11, 2018 8:04 AM

Leave a Comment


This Blog



No tags have been created or used yet.


News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG

Privacy Statement