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), 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



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
Anonymous comments are disabled

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