Thanks, Mani. Will give it a go, and get back with results.

Cheers,

Chris

Nothing gets written to that file. I am executing only the offending step, and I have to manually stop the job.

Any other logs I can check?

Hi there,

You mean on the Advanced page of each step? I have not tried that... wasn't sure if it would be helpful.

Will give it a go.

Thanks,

Chris

Hi Steve,

Thanks for the link. I actually saw that in my research but it seems that they integrated it into early 5.x versions, yet others have had it crop...

Hi all,

Thanks for the response, and your willingness to work on this thing with me. I greatly appreciate it!

Jeffrey, this is the sort of thing I was thinking I...

Ok, finally had a chance to look at this and digest it.

It seems that Mark's solution will still leave me with the same number of statements, meaning I will still...

Cool, guys! That's what I was looking for, I think.

Thanks for the help. Much obliged.

Cheers,

Chris

Ok... the end table is nothing that is defined, just a feed for a report, so it is built from the 130 or so subselects.

Here is the SP that gathers...

Hi Hari,

I got that about UNION from what I saw happening.

I thought I posted some examples there... I basically need to create one single-but-wide row from multiple subselects, however...

Hmmm... now you have me thinking...

If the goal is to try to structure data and queries to hit only one server, it seems that (my perception of) the benefits of...

Hi Michael,

Thanks for the response! When you say I need a key (I am assuming that was a typo?) that will allow the cross-view lookups, will a typical auto-incrementing...

Hi Vladan,

That looks like it will work as well, but, and I know I wasn't very clear in my original post, I was trying to avoid the temp table/subquery, which...

Cheers!

It's more of a job-title than anything... I am actually a writer/director. Software consulting is just my hobby. 🙂

C

Mr. Matt... I bow to your expertise and the depth of your knowledge!

Works perfectly.

Thank you!!

Hi Matt,

Maybe I am doing something wrong, but I am getting the total of all promo_disc_amt for every line in the criteria, including the dupes.

If I do:

SELECT DISTINCT order_key, promo_disc_amt

FROM...