yes inserts only, and yes simple ascending IDENTITY.

As immediately as possible.  Primarily used during an update so that they can see what is failing.

Not sure that SSIS can do continuous...

:w00t:

Sorry, I get a little hot headed when deadlines come and go and nothing goes as planned.....

I think the Red-Gate toolbelt is really a fine product, however I can never...

so easy to install --- such a pain in the *** to uninstall... 15 separate items all need to be individually uninstalled, and then half of them open...

Thanks..

So Do I understand correctly that coalesce would be best in a situation like this>

COALESCE(myalpacolumn,mynumcolumn,mybinarycolumn,'') As mycolumn