The above code worked perfectly. I changed '(job outcome' to '(Job outcome)' but other than that, this meets the need exactly!

Thanks!

That is EXACTLY what I need. I changed it to this which makes a little more sense in my head...and seems to provide the same result.

UPDATE D SET Drop_Or_Live =...

Thanks Jack. Good idea to run the profiler. I will dive into this.

Thomas

When I create users manually I don't do anything with IIS. We have it set up to where all users can see all reports. I believe IIS just lets anyone...