From memory, I think this product does

http://www.raxco.com/products/perfectdisk2k/

Hope it helps.

Alternatively, SQL Queries for Mere Mortals (Michael J. Hernandez, John L. Viescas) ISBN 0-201-43336-2

This was recommended by tutors as a foundation prior to undertaking MCDBA cert.

Here we have the same environment.

Check out BOL for

1. sp_addlinkedserver - You need to firstly set up the linked server

then

2. sp_addlinkedsrvlogin - set up a mapping between the local...

Try this:-

SELECT c.OrderId, b.[Max Qty]

FROM

(SELECT MAX(Qty) AS [Max Qty]

FROM

(SELECT OrderId, SUM(Quantity) AS Qty

FROM [Order Details]

WHERE OrderId BETWEEN 11000 AND 11005

GROUP BY OrderId) a) b

INNER JOIN

(SELECT OrderId, SUM(Quantity) AS Qty

FROM [Order...

Gee,

Got excited for a moment. Thought I'd got a reply.

Any help is appreciated.

I'm ok with indexing strategies etc, it's purely concerning the defined/not defined relationship prior to creating a JOIN.