The concat null thing is supposed to go away in a future version of SQL. IsNull (or Coalesce) is definitely better.

Any way to consolidate the two?

If not, I'd need to see the code for the tables (create scripts), and the code for the trigger. With that, I might be...

davtt (8/20/2009)

---

Fair Comment!

What you say is that a good developer will normally be an OK TSQL programmer. That is sort of what I mean. I would agree that some...

You're welcome.

We all have to start somewhere.

Are you moving a specific table, or a whole database, or part of a table, or multiple tables? Will you be doing this once, or repeatedly? Are you...

Take a look at IsNull in Books Online (the help file for SQL).

If you put IsNull(MyColumn, ''), it'll put an empty space where the column would be if it's null.

Why have two tables with the same data, even in two different databases?

We've had that discussion numerous times on this forum, and it always comes down to it having too many problems.

The only efficient way to do it is intermediate tables. You can violate normal forms horrible and do it all in one table, of course, but the cost on...

If you set the e-mail type as HTML, you can do something like this:

declare @Body varchar(max);

select @Body = '

';

select @Body = coalesce(@Body + '

My Column Header 1	My Column Header 2
'...

First, you look at the data-size expected in the tables, and you look at the expected volume of inserts and deletes. That'll tell you what to expect for each...

Set up a VM with a copy of the databases that they need access to. Set the databases there in read-only mode. Give them full access.

Refresh the databases...

You might be able to simplify it by creating a user data type, and constraining the data type. Not sure that would solve it, but it might help.

It would...

davtt (8/20/2009)

---

Silverfox - I don't know where your developers are trained then!

Almost all the developers that I have had the pleasure of working with throughout the years have had...

Sounds like the old issue of central command being consistent but distributed command being fast. Nothing new, just new ways to implement answers to an old question.