What a coincidence. In a thread below that I read, I learned that this may be the EAV model.

Understood, KGB. This is not associated with an app. It pertains to a batch import. We would be receiving a table with some combination of attributes populated...

That was an interesting article indeed, Evil Kraig F.

I would be comparing two tables (vs. a set of variables or one row). Using my shoe example, I would compare...

I figured out the issue. I had line feeds at the end of some values.

The secondary issue is that the manner in which I examined the values did not...

As another test, I tried exporting with bcp. Same result.

Wonderful. Thank you.

Michael Valentine Jones (11/11/2008)

---

A NATURAL JOIN is an inner join where the RDBMS automatically selects the join columns based on common columns names. Some RDBMS vendors, like Oracle but...

The point of my original query, as you may have guessed, is to help me overcome the poor test score (assuming "NATURAL JOIN" is truly not supported syntax).

Well, I'll tell you the way it was used that was very painful for me. I just took a test on SQL that had statements such as...

SELECT *

FROM table1

NATURAL...

GSquared (8/6/2008)

---

They're all going to be in that business.

Why not install a copy of Dev Edition on a home PC? You mentioned you don't want to, but I'm curious,...

Thanks to you both.

I have been using the online backup service offered by Mozy (www.mozy.com). There have been some minor glitches but overall I have been satisfied. There are other comparable...

Michael and Lynn, thanks much for your feedback.  I really appreciate it.

 

MVJ, thanks much.

Why is that best?  Is it best because it is not converting it to a varchar?

Mark,

We have been dealing with the batch loading issue too.  I like your method.

Regarding the BEGIN/COMMIT TRAN piece, somebody suggested to us that we simply issue the CHECKPOINT statement instead...