Hi Phil,

Yes, the job fails at the same point each time.  The point of failure is after the bulk insert when I transfer the inserted data to another table. (Around...

Take a look at SET ANSI_NULL setting in the help.  This maybe your problem where <> NULL evaluates to UNKNOWN.

Thanks for everyone's recommendations.  The APP_NAME() function will do the trick in my case.

srv

That should be

select @EchVpoin = 1 / @totlMd

instead of

@EchVpoin = 1 / @totlMd

srv

See the two methods below.  Method #1 will have terrible performance if your employees table has many rows.  Method #2 performs the count(*) once into a...