In our case, the term "clone" would be more appropriate.  Not sure how it works, but it just takes a couple of minutes everynight on a tera-byte database.  Has something...

How does that produce the dynamic sizing the OP asked for? That code works great on the input but does nothing for formatting the output in the text window.

Michaeal said it right...

There's too many tables being updated, so a trigger is out.

Write a sproc to generate the trigger code...

It would be good if you posted one of the offending lines of code (sans password)... there's lot's of options in BCP...

Good golly, folks... open Query Analyzer and press {f4}....

This probably doesn't help, but the right way to do it would be to deny all users the ability to create procs and to follow a code promotion process.

Thanks for taking the time for the explanation, Rog...

But... being able to pass tables to stored procedures, with the understanding that you will have multiple tables with the same...

Let us know what you finally come up with so that others may learn, as well.

Heh... did you try it?

http://www.sql-tutorial.net/

http://www.firstsql.com/tutor.htm

When you get done being a newbie, then practice answering question on this forum as Serqiy suggested.  You also may want to take a peek at...

http://www.nigelrivett.net/

Remember...

Sounds like you need an intro to SQL... here's a good overview...

http://www.sql-tutorial.net/

 SELECT MIN(fName),Age

   FROM yourtable

  GROUP BY Age

Although not sure why you want to give the alphabetically earlier names such a break.  Why do you need to do this?

Outage = perception

... or ...

Outage = contract stipulations

On the perception side, if you can't do your job because some system is down, I'd consider that an outage.

I won't get into...

Please post the query that you've tried, so far... I'm thinking all we need to do is change one of the joins to an outer join and use ISNULL(columnname,0) on...