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

Depends. If you're talking about the Thorsday joke, my father tells it all to frequently. If you're not, do...

Thor

And knowing is half the battle.

Yes.

@=)

GilaMonster (11/3/2010)

---

I'm running SQL 2008 and SQL 2008 R2 (developer edition both) on my desktop. R2 replaces 2008's management studio and BoL, but no problems on the DB engine.

I would...

morning.

urgh.

Just got me a Dev copy of R2 and am uninstalling the regular 2k8 eval copy from my laptop now. Gonna play, gonna play.

I'm debating on getting a Dev...