Of course your manager will thank you for this - all the way to THEIR next (big) pay raise...

Not me being cynical - this is experience.

And this is after you've...

First 'WITH' is (I think) a typo.

As a Highlander once said "there can be only one... :)"

USE AdventureWorks2012;

GO

WITH

-- First Subquery rewritten as CTE

WITH Sales AS

Otherwise, all good stuff!

Interesting.

But source code/DLL please?

However, if you have to sit down and teach (basic) SQL to non-techies (in my case, pensions administrators) it could prove quite useful...;-)

The supplied templates are also a great self-tuition tool for budding DBAs (and others! like moi for instance).

I try to set aside some time every session to browse through the...

Thanks to all who posted a response to my query.

I'll change the target table to have an "identity" column asap.

Gratefull regards to all!

OK,

you're all being kind to me aren't you?

Of course I screwed up the UK to US gallon conversion - put it down to an un-airconned office with temps of...

Damn!

so my Yaris is getting about 91 miles per US gallon?

So why does my wallet still hurt so much...:)

Hi Steve,

Diesel is currently 129.9 per litre here in NE England. By my reckoning that roughly equates to just over $11 per gallon.

I drive a Toyota Yaris turbo-diesel and average...