Thanks Lynn, that was the problem... darn I did not even think anything when I read the T-SQL.. you were right that they created this as a maintenance plan. Interesting...

Alexander Suprun (9/7/2012)

---

dwilliscp (9/7/2012)

---

To write new data using three outer joins or to use one outer join, and get most of the data, then use three updates to load the...

The problem with that...

When you view the history..

Error Number : 0

Error Message: Alter failed for Server

However since we were using the bottom section..not top.. domain accounts will not work. Thanks for your help.

I found the following interesting.. it seems to state you can use windows passwords in the upper section, but when you get to the bottom of the box you can...

ChrisM@Work (8/16/2012)

---

Of course, unless there's something in Notifications to identify which...

I ran the below statement.. with a modification for a link on material number (cutting the list down by 638 from the posted code). I will run this past the...

Luis Cazares (8/15/2012)

---

Have you used one of the solutions we gave you?

Lowell's might return duplicate rows (because of the extra inner join), but Chris' and mine should not have...

Luis Cazares (8/14/2012)

---

Is REF_DOC a unique value? Or do you have it several times in ztb_Carrier_Delivery_Metrics?

As I see it, this is a problem with your data.

EDIT: Could you show us...

ChrisM@Work (8/14/2012)

---

dwilliscp (8/14/2012)

---

dwilliscp (8/14/2012)

---

Thanks for your help... I just could not figure out how to word the statement ... looking at some samples I found on the internet.

Thanks for...

dwilliscp (8/14/2012)

---

Thanks for your help... I just could not figure out how to word the statement ... looking at some samples I found on the internet.

Thanks for the help...

Checking the data.. there might be something wrong with the join too... I would expect that all this would be on one line... but we might be getting extra lines...

Thanks for your help... I just could not figure out how to word the statement ... looking at some samples I found on the internet.

Thanks for the help from...

Yep that works, thanks. Wonder why it needs the brackets.. oh well, thanks for your help.