According to Itzik Ben-Gan, a subquery is any of the scalar, multivalued or table expression queries written into an outer queries. He then goes on to refer to the scalar...

He means it sounds like homework.

I'd suggest using a subqery with a TOP and ORDER BY.

If you're trying add these values to a CTE, wouldn't you use UNION? Probably in a second CTE.

There was absolute agreement on the OUTER JOIN being an issue. The question was, did placing filters on the INNER JOIN make a difference? Several people anecdotally believe(d) so (myself...

mtassin (7/11/2008)

---

Grant Fritchey (7/11/2008)

---

You know, either way works for...

Generally, I've just passed all the fields back to the proc and updated them. Depending the app & the business needs, it usually doesn't matter if FieldX is updated from...

The time differences on those are pretty trivial. The same number of scans and the same number of reads usually tell you most of what you need to know.

You'll have to store the symbol and it's associated currency in a table in order to select on it. Otherwise you could create an enormous CASE statement, but the first...

ANSI settings are different for that user than the others. Probably, but not definately, ANSI_NULLS.

That sure sounds like homework.

Generally, for homework type questions, most of us ask that you post what you've tried to do and where you're having problems. That way we're helping...

Not for OUTER JOINS though. With...

You know, either way works for me, just put...

Christian Buettner (7/11/2008)

---

Hi Grant,

what makes you sure this time that it does not make a difference?

Did you get this information from Microsoft ?

I am pretty sure that I had examples...

Well, eliminating all the excess JOINS does improve performance threefold in this example, so I think you can reasonably expect the something similar with larger data sets.

Because of the OR...

I've got nothing. The examples I thought I had, I can't find.

My heartfelt apologies for putting out bad information. For an INNER JOIN, it really makes no difference in terms...