If you omit the rownum column from the result, the query plan can use the ANY aggregate:

SELECT

X.Item,

X.OrderNo,

X.OrderLine,

...

Lynn Pettis (5/5/2012)

---

I...

The explanation could be better. The question does not involve a float value. By default, the literal value 0.25 is interpreted as a numeric(2,2):

SELECT

0.25...

Sure. The work table in the...

Jeff Moden (5/4/2012)

---

I think the extra sorts are absolutely worth it, though. They get rid of the accidental cross join, nearly an order of magnitude of reads, and runs...

Jeff Moden (5/4/2012)

---

Ah... got it. If you change your LEFT OUTER JOIN to a LEFT MERGE JOIN, the accidental cross join goes away, reads drop from 40 to 6,...

This is one type of problem where it is perhaps easier to see the logic using SQL Server 2012 syntax:

DECLARE @MyTable AS TABLE

(

idLigne ...

How about:

SELECT COUNT(*)

FROM

(

SELECT ProductID, Location, SUM(cases) as TotalCases

FROM dbo.TblProduct

GROUP BY ProductID, Locations

HAVING (SUM(cases) <> 0)

) AS Query;

drew.allen (5/3/2012)

---

If it's so...

mtassin (5/3/2012)

---

Hugo Kornelis (5/3/2012)

---

What bothers me (about the documentation referenced, not about this question) is the relative order of ON and JOIN - how can the ON be processed without...

opc.three (5/3/2012)

---

I don't know about this one, Paul. I see this type of comment a lot on the net...that the bar is simply too high to get started with SB...

Lynn Pettis (5/3/2012)

---

Not trying to make my...

One possible test is to imagine one's mother reading the post before hitting 'reply' and wondering if it would make her proud.

I'm not sure The Thread actually has any special...

Shelly,

The 1 row estimate, 250052 actual occurs on the Key Lookup. This is how SQL Server looks up columns in the base table needed for the query that are...

GSquared (5/2/2012)

---

The parentheses on Top are only needed outside of Select statements, but whatever is wanted on the standards for that. That's style, not function, so whatever you like...