I have to admit, when I saw

it crossed my mind that this was an early April Fools prank, but no, not at all. Very impressive...

Yep Tomm, you're right: But the...

Tomm Carr (3/19/2008)

---

Am I missing something or are you guys making this much more difficult than it should be? In general, you can do this:

select

from whatever-to-get-original-resultset

union

select

from...

Hi Art

Does the query give you the results you are expecting and have you checked that they are correct? Can you post the whole query please?

Cheers

ChrisM

You're welcome, Ahmad. Hope it helps. I'm sure people will chip in with their expertise in the areas...

Brandie Tarvin (3/19/2008)[hr

Oooohhh. Idea!!! :exclamationmark: Let's build our own maturity test. We've already got some of the basics in this very thread (RPG / Exotic Foods / Etc.)......

Art

If you switch your LEFT JOIN to dbo.OrderFormLineItem for a derived table which performs the aggregate to obtain the most recent shipping date, then you could get lucky and lose...

Erm, Oracle Application Developer? The only one of these I know is rarely off-piste at around £500-£700 per day. Yep, them's British...

Hi Ahmad

Your original question arises so frequently that it it would be worth answering your last question in a formal manner, as a permanent reference. But for now, as I...

:Whistling:

Nope, that was a Moden 😛

It comes down to using a tool you feel comfortable with to do the job really doesn't it?

Jeff, you like playing with macros in Excel - I used to...

Roy Ernest (3/18/2008)

---

How in heavens name did we end up with exotic food when talking about interview:D

Since the topic is already there, has anyone had Bat? You know , the...

Good luck, Ahmad!

To be honest, this isn't how I write to Excel using SQL Server, as I mentioned earlier. I use TSQL to copy/rename an Excel template, then server linking...

Use derived tables in preference to temporary tables, and as Grant states, avoid using DISTINCT:

SELECT *

FROM FIRSTTABLE s

INNER JOIN (SELECT PKID

FROM SECONDTABLE

GROUP BY PKID) d

ON d.PKID = s.PKID...