It sounds like you're debating normalized vs. denormalized data.

For very simple select statements that don't involve much in the way of filtering, but simply pull data based on a key...

No kidding, drop the grenade & run...

They could be doing something silly with reseed?

I'm running it side-by-side with 2005. One of my co-workers has 2000, 2005, and 2008 all running on his personal machine with no issues from any of them. The same...

Maybe something like this (untested since you don't have structures posted):

SELECT T_OrderHeader.OrderID,T_OrderHeader.CustomerID,T_OrderHeader.ShipTitle, T_OrderHeader.ShipForename,T_OrderHeader.ShipSurname,

CONVERT(NVARCHAR(20), T_OrderHeader.OrderDate,...

It's hard to tell you explicitly what happened without the data and structures, but you seem to have a data issue: "Error converting data type varchar to numeric". That means...

The secret to dancing is to not giving a flying rat's patootie what you look like while dancing. No, it won't make you dance better, but you'll have more fun....

I work for a larger company. We don't spend a lot per person and nothing like 5%, that would be great. However, they do have tuition reimbursement and the boss...

That's where I was trying to get with the do vs. juisu. Look at an Iaido practioner and then an Iaijuitsu practictioner. The difference is huge, although, to a degree,...

Personally, I'd use BIDS, but that has a bit of a learning curve to it. You might want to start with the wizard to see if it will do what...

abatej (8/14/2008)

---

I find it interesting that there are so many of us that are also martial artists. I have just recently passed my 1st dan black belt test in...

So change the JOIN on that table to a LEFT JOIN. That means all the data will return from the main table and only those rows that match from the...

You can make the foreign key non-null, which will force you to have a value, and you can put a unique constraint on the foreign key, making it so only...

There's do and there's juitsu. The "way" or do study in martial arts is a spiritual excercise. The juitsu or "art" is martial in it's intent. Meaning, we're not so...

Well, to quote Adam from Myth Busters, "That's your problem, right there."

Relational data storage more or less requires relationships and those are defined through constraints on the tables. Probably, even...

You also may have columns inside tables with different collation settings. Check that.