No need. I have already filed the solution you posted in my toolbox. Thanks 🙂

I just want to say again that your solution was really pretty Jeff. Mine was also based on a ctes using row_number(), but yours was much...

I wasn't going to bring that up, because, despite the name, I don't consider extended stored procedures to be stored procedures in the sense the author of the question meant....

If they won't link back, then go with the parameter passing option in my last post. We can discuss that more if you need to. ...

Orson Scott Card (Ender's Game) is a great read for kids. Follow it up immediately with Ender's Shadow and then have a very interesting conversation with your...

Also consider "The Jungle Book". Most of the stories aren't for the faint of heart. (Disney got it all wrong.) But it was one of the first...

Also, just in case you are tempted to explain why it HAS to be a function and not a stored proc. Please, don't bother. I have had a...

Functions can't call stored procedures. Sorry, but you have to re-think what you want to do.

You can write a stored procedure that uses a...

Same principle, but much quicker than my solution for sure. Nice clean piece of...

An alternative to the view/table scheme above would be to pass the list as a parameter to the proc on SystemB. This might be necessary if you couldn't...

In our setup, both systems are linked servers with respect to each other. I created a view (could just as easily be a table) on the calling system....

No problem, Steve. I like that plan. I'm excited to be...

Hey Lynn,

I'm about to head out to lunch. I sent you and Matt the solution though.

If you're going to tell them they're not posting right then it would be a good idea if you could give them the link to the information about the right...

Matt and Lynn,

I'll go ahead and send you my solution, so you can double-check me. I did it with CTEs and freely admit there is probably a...