I should have been more clear, I do want a third column that is the combination of the two. Thanks for the suggestions!

Thanks! Once again you've been a great help Peter!

I think I may have found this in the DTS transformation Define Columns fuction and changing the drop downs to non quotable.

Hopefully the last issue in this thread, the output from the last query above is putting " " around some of the data and causing issues with processing the file....

This is what seems to be doing the trick and here are the run times, quite a bit different!

SELECT D.ProjectID,

...

Hmm, now I'm pulling too much data back. My objective is to get the MAX or most recent record from the history table and ONLY that record. This query does...

Peter

Much thanks, for some reason (I have to admit I'm not great at JOIN statements) the query threw a syntax error. Through some trial and error I got this to...

Thanks Tom, we're still struggling with this and will give this a try.

Ron

Not yet, I found this link, but haven't had the time to try to fix this, if it help you will you post here and let me know?

http://support.microsoft.com/?kbid=814441

Rec'd and replied to, many thanks.

We're flexible on that point since we have both enviornments. Send me an email if you're interested in helping us out.

Tested, got msg saying Succesfully Started and Stopped MAPI blah blah. Reran TSQL, same error msg. ;-(

Ditto that Site Owner, thanks for the bump.

No interest at all? This is relatively easy work for the person with the right skill set. We have no legacy data,...

Thanks for the advice.

I think I was having two problems at the same time, first was the lack of having the extra columns in both the select line and the group by line...