Phil Parkin (1/15/2011)

---

An alternative is to create a mapping table in SQL Server and use a LOOKUP to get the result you need. Much easier to maintain and handles easily...

allmhuran (1/15/2011)

---

Thanks for your feedback. Yep, this is exactly the kind of stuff I'm thinking about.

We are actually using the addin at my place of work with great success. I'm...

Migrating data from what to where?

In the same DB? In the same server? Or across different servers?

What is EMPTY? Is it an empty string? A single space? Multiple spaces?

In the case it is an empty string, you better trim the column first and then check if...

It works with me on SQL Server 2008 R2.

Are you sure there is not a typo in the name of ServerB?

Can you give a little more information?

What version of SQL Server are you using? What service pack level?

What do the queries look like? Are you using a linked server?

Are you...

If you are on your own, selling it will be tough. Companies usually don't just install everything on their computers. You have to convince them. And you have multiple people...

I think it is a great suggestion.

But as mentioned in the...

It is like watching a horror movie....

GSquared (1/14/2011)

---

Jeff Moden (1/13/2011)

---

Stefan Krzywicki (1/13/2011)

---

Maybe other folks will leave it, but I'll stop and pick it up. ...

Come on come on. Don't exaggerate. I hear they are just fine for starting a nice...

This will work if the data comes out of a flat file.

However, no one in this thread has mentioned...

Isn't it possible it was a self restart?

Another solution, but harder to maintain and probably not so good for performance - is to set up triggers on tables that contain critical data. If a delete is performed,...

The second code will surely be much faster, but you've hard coded the condition into your statement.

Are you sure there will always be one row in table2 with col2 =...