Thanks for pointing me in the right direction.

I ended up turning this into a job.

I'll share it after it's been tried and proven.

SELECT*

FROMDistribution.dbo.MSdistribution_agents DA

INNER JOIN Distribution.dbo.MSdistribution_history DH

ON DA.ID =...

Thanks for responding....

Great! Exactly what I needed. Thank you.

Here's my code. Still fresh, so needs to be tested more.

-- Run this code from the publication database

-- Code assumes some form of naming...