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.

Since you can't code 'USE @Dbname' you need to do something like this:

But when you do this, it still runs from within the master db.

You could modify...

Tami D (10/23/2007)

---

Thank you for the response. Unfortunately, I am using an output parameter and do not have the luxury of just excluding the column in the call to...

Even though I didn't have all the information, despite the number of rows, it's not a very big table. I did some experimentation. They shouldn't be hitting any issues assuming...

webrunner (10/23/2007)

---

Jereme Guenther (10/19/2007)

---

I don't know how or if you have time to read all of these posts, but here are my stats.

I obtained a BS in Software Engineering picking...

I set up a sample using these scripts:

CREATE TABLE BigTable

(

ID INT,

Date SMALLDATETIME,

[Value] decimal(18,10)

)

WITH x AS (SELECT 1000001 AS Id

,GETDATE() AS MyDate

,42.2 AS MyValue

UNION ALL

SELECT

ID + 1

,MyDate

,MyValue

FROM X

WHERE ID <...

I've never heard of anything like that. Best guess I can come up with (and it stinks) is to run spell check on the fields after you concatenate them...