Deleting Old Mirrored Posts via Stored Procedure

I'm writing a stored procedure to periodically delete posts that are older than
XX days from the cs_Posts table, if they are from mirrored feeds (e.g. my
external news).  This part was relatively easy, especially since there have been
a few posts on a similar topic in the past few weeks.    My problem is that I
also noticed that cs_RollerBlogPost contains the permalinks associated with
these mirrored posts, but I'm having a harder time getting the script to
match-up the PostID from the one table to be able to delete elements of the
other table.

I would appreciate any assistance from my developer savvy colleagues...

And look what I just found...

http://joeriksson.com/archive/2006/12/11/set-your-reader-posts-to-expire-automat
ically.aspx

J-O to the rescue again, even if he didn't know about it.

Yea he is good for that!

Hey, J-O is Mr. Wonderful in my book, but this ia actually different from
deleting old Mirrored Posts.  That post has to do with the Reader feeds, which
is something different.

Maybe if J-O sees this he'll add that to his "to blog" list.  

-Dave

You're correct, Dave, but what he provided helped me out anyway because the part
that I needed assistance with was how to use the data from one table that had a
date (in this case the FeedPostID) to access the corresponding info in a
different table without the date.   This methodology was addressed in his SQL
code, so I was able to use the same approach to deal with the two tables I cared
about.