No - I never managed to get it to work.

Here we go again.

Inevitably this discussion comes up. Inevitably the answer is that women just aren't fit for IT, because they're sweet, mothering types that can't hack the competitive...

Wow - that did just what I needed and worked amazingly well.

I am in awe!

And even better, I think I understand it.  (I'm a total n00b).

Thanks much!

I'm not having a lot of luck with this, because it's MySQL, I think.

Here's the error message I get:

A four-part name was supplied, but the provider does not expose...

Okay, I found the following in the help and don't understand how to get all of this information:

After a linked server is defined, to reference data objects in that linked...

That did the trick!

Thank you so much - I've been banging my head on that for days.

I am trying to update a text field with the information from an identical text field in a view in another database on an ongoing basis. 

Here is the definition of...

I borrowed this code for our Cisco CallManager database exports - works wonderfully for our purposes.

Thanks for posting!

Thanks a bunch - that not only works, but makes a lot of sense!

Thanks - that makes a lot of sense.

I'm having a problem with applying it and I've determined that the problem exists when the script encounters an existing condition that matches...

My table has two columns of importance - ContactID and Category.  The table's name is ContactMoreInfo.

I want to find every ClientID that has a Category entry of 'Gift 2005'.  If...

"What I need to do is take a table and insert a new record for each result that matches a select statement.  I'm not certain of the best way to...

Can you please clarify?

From my understanding, that seems like it's just giving a row count, which is not what I need to do at all.

Thanks.