Cross Apply

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.

APPLY - 2

APPLY - 1

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.

RE: English in Script Comments

Steve mentioned "I typically don't review the scripts when they are submitted because honestly I don't have time". I'm sure this is true of the other site owners as well. Would it be beneficial to the community as whole if there was a group of reviewers that performed this function? I'm sure in a community […]

RE: Frustrated by SYNTAX ERROR

Thanks for the kind words Tim, I'm sure one day you'll be helping me out with a problem.The beauty of these forums, is that there is always someone willing to help.Shane Stecher

Calling reportserver at design-time

Hi, I'm implementing a web control component for displaying reports using the web service. It works really nice, but now I'm trying to get a hold of the parameters defined in a report at Designtime, so that I can set up the default parameters automatically. And this is where the problem arises. When i try […]