You haven't offended. I just wanted to make sure you knew the proper behavior so you wouldn't have problems in the future.

On the other hand, the poster hasn't responded to...

coal

brainblower13,

Quick question, and please don't take this the wrong way.

Have you ever written an INSERT statement before?

Given the fact that you're trying to cram multiple rows into one SELECT...

I did archery (lousy archery) when I was a kid. Been thinking about getting back to it, but the local sports stores only carry hunting bows and I don't want...

EDIT: GAH. Wrong thread. Let me go back and re-read.

A CTE is not necessarily better overall. I've seen CTEs that kill performance in certain circumstances. Sometimes...

Vacation.

Over, alas. Back to the desk now.

Ali, be careful about...

Thanks to everyone who's posted a response. I see I have a lot of testing to do.

Someone mentioned removing extraneous spaces. In this particular case, there are no "extraneous" spaces....

Maybe I'm misreading your solution, but it doesn't seem...

Jan Van der Eecken (10/18/2010)

---

Hi Brandie,

I guess the final update back will fail on a database with a case sensitive collation. Shouldn't it rather read:

Update idf

Set Location = mt1.Location

from dbo.Import_Data_Filter...

Not necessarily true.

Talk to a business user once in a while (someone who's used Lotus or Excel or Access) and you will find they...

And if she chooses not to, a new topic of discussion. I'll start.

TOPIC: Things you should never tell your parents

How those footprints *really* got on the ceiling.

Welcome to the group! It's nice to meet people from the international SQL Community.

<headdesk><headdesk>

New WOTD: groan