Drew Mayo (10/26/2007)

---

Kelvin Lush (10/25/2007)

---

I see nothing wrong with this question. It is basically trying to test whether you are using the ANSI standard JOIN syntax or the older syntax...

I don't have a solution, but possibly an idea.

I live the first few years of my life in a VERY small town in Southwest Missouri called Sarcoxie. For a while...

Sorry, I just plucked it from the middle of existing code. Our system has one table that doesn't have versions and all the rest do. So the query included the...

We also did some this way:

SELECT...

FROM Table x

CROSS APPLY (SELECT TOP(1) whatever..

...

We had a similar problem and solved it, nicely, like this:

SELECT...

FROM Table1

JOIN Table2

on table2.PK = table1.Pk

and table2.AuditDate = (SELECT TOP(1) t2.AuditDate

...

They've already had several instances of "Oh, I forgot to add that WHERE thingie to the query."

We did win the support argument. We've pretty much told them, if they tank the system, our only troubleshooting method will be a restore or restart the server. No other...

AAARRRGGGGH!

I can't believe I got such a simple question wrong. Reading the question carefully really does matter. I saw amalgamate & rows and didn't see the word tables in between......

Pick any rule you want and then follow it consistently.

Personally, I'd use camel case, or bumpy case so that the column would be:

AfterGlowLightingCompany

But honestly, if you don't mind a bit...

Check to see if anyone has set collation on the columns different than the collation for the server. That would explain why only some of them are having the issue.

There's just not one right answer. The question you have to ask, in addition to the structure, how will the data be accessed?

For example, CustomerCode on your Customer table sounds...

I can't see it, but somewhere in there you're adding or setting a string to a number.

Try debugging it by adding PRINT Statements to watch the values change. That's...

I don't know. I lost the training argument too. I'm looking up at the two book set of structured classes, lesson plans, documentation and tests that I had to spend...

Sincere apologies, but I can't understand the question or the requirements. A little clarification maybe? Possibly some table structures and maybe some of the code that you've tried so far?

Take everything Gail says to heart.

In addition, you might want to check out this article[/url].

It's meant as a basic introduction to checking performance of your system.