SELECT *

FROM

(SELECT DealerCode FROM Sales GROUP BY DealerCode) m

CROSS JOIN Forecast fc

LEFT JOIN [Sales] s on s.DealerCode = m.DealerCode AND s.ForecastID = fc.ForecastId

ORDER BY m.DealerCode

SELECT *

FROM D

LEFT OUTER JOIN a

ON A.a = D.a

WHERE

A.b = 1 -- << this turns the LEFT OUTER JOIN into an INNER JOIN

AND D.a IN (1,2,3,4)

-- use this...

-- The query requires a scan of the whole 100M rows to evaluate the ORDER BY.

-- An index with Destination, Origin, Airline and Tax will help.

-- You *probably* don't need...

GilaMonster (8/21/2012)

---

<soapbox>

Cursors are tools. Use them where they work, don't use them where they don't. Statements like 'you should never use a <whatever>' are just shortsighted

If we count while loops...

Green Day

dwain.c (8/21/2012)

---

It has been a rare experience for me to post a question to this forum, but I will now. How about a poll?

Yesterday I was called upon to...

Stefan Krzywicki (8/20/2012)

---

Brandie Tarvin (8/20/2012)

---

Landlords in the States are adding it to the usual rental fees as a way to discourage pet...

SELECT -- resolve "word" between 5th and 6th pipe characters using Cascaded (CROSS) APPLY

WordInRow3 = SUBSTRING(row3,r5.p+1,(r6.p-r5.p)-1)

FROM (SELECT Stringy = @text, LineDelimiter = CHAR(13)+CHAR(10)+CHAR(13)+CHAR(10)) d

CROSS APPLY (SELECT p = CHARINDEX(LineDelimiter,Stringy,1)) x1

CROSS...

Interesting

jfowler 10337 (8/17/2012)

---

i read it....my mind just doesn't get computer code lingo all that well. If I posted the data of the tables I'm pulling from it would be...

Stuart Davies (8/17/2012)

---

ChrisM@Work (8/17/2012)

---

Stuart Davies (8/17/2012)

---

ChrisM@Work (8/16/2012)

---

Earlier this year I had an interview for a gig right next to Swindon station, a dream forty-minute commute compared with the two hours...

jfowler 10337 (8/17/2012)

---

ok, thanks. I was hoping it would be something as simple as looking at the code and changing something in the grouping. I've inherited the code,...

There are 13 selects in your query - each one has to be aggregated at...

No problem.

Run the results into a temp table, index it, and select with an aggregate.

Tiger moth