you're still looking for lvt.ID in a query that only has LVCalls in the from statement

nope. you'd get this error as stated in the article:

Msg 4104, Level 16, State 1, Line 2

The multi-part identifier "lvt.ID" could not be bound.

Hence the use of apply (or row_number).

P.S. great article!

my first thought was to set up a CTE for the transactions, then join that to the Call data and use TOP 3. If the data can be returned on...

I'm also in the "only drop the stuff that's never used" camp. the systems i work in are under constant development, so sometimes one approach to a problem will be...

I get the day off from the usual log-jam of my commute, since myself and 11 other people (judging by the traffic count on I-93 this morning) are the only...

Personally I would rather have a more conservative leader that values aggressive advice, and acts on some of it, but stewards the business rather than runs along embracing each new...

Our analysis of the data warehouse has revealed the following compelling trends:

currently, an astonishing 100% of Porsche owners living in Colorado and named Steve Jones are happy with their vehicles,...

Global Warming is a touchy subject because it's virtually impossible to have conclusive evidence that proves or disproves its existence.

Those who advocate action to attempt to remedy the (apparent) situation...

I trust people to be self-interested until i know them well enough to trust. i've been lied to by people i trusted and robbed by people i welcomed in my...

just think "Mmmm templates"

As has been discussed by a few different posters, there are certain professional groups that require membership in a larger organization (i.e. Medical Personnel) that enforces ethical practices.

I would argue...

Core Design Challenge? Make it work.

Well worth the read, as always. Thanks, Phil.

Huzzah!

Huzzah!

Huzzah!

Juno and Dark Knight were both really good.

I saw The Day the Earth Stood Still (the remake), but it wasn't worth seeing.