I can't test the openquery part of your code but I am pretty sure that the double quotes are your problem.  I also added a bit to your sp_executesql that...

See what happens when you make the following change:

ALTER FUNCTION [dbo].[GetTenPercent_Moss]
(
@parentId int,
@sampleyear int
)
RETURNS TABLE
AS
RETURN
(
  SELECT  TOP (10) PERCENT
       ...

I wonder whether I will be cast out from The Thread as a maverick grammar nutjob for suggesting that NSO would be a better abbreviation, given that 'verbal' means...

You do know you have to toot your own horn, right?

Let...

You do know you have to toot your own horn, right?

Let us...

Sheesh, week 13 and the playoffs are already set!  And I'm on the outside looking in...

For those out of the playoffs, there's still seeding for and competition in...

This looks like the earliest this has occurred. Normally it seems to go until the final week to finalize the top 6.  Didn't think I would make it based on...

This explanation...

You want the best help, post the full SQL code and the error message you are getting.  Posting a tiny snippet does not provide the context needed to really help.

Would help if I checked my line-up more often, nothing like missing that your QB is on a buy week.

I won't be at PASS 2019, but I plan on registering...

Glad to see that someone rewrote the multi-step tvf to an in-line tvf.  That really should help the performance, but of course ymmv.

Yes, I am confused as well.  Good thing I am at work so...

Oh for crying out loud!!!  None of my RBs or WRs even bothered showing up yesterday!!!  (And the one who did was on my bench!)  @#$%^&*!!!!!!!!!!!!

So...

re "for part no XXX708, it selects 3 warehouses with no activity but there are 2 more with recent sales"

I think the initial query I gave you should work:

Thanks for the very kind feedback, Jason.

Interesting code, Jason.  While I've seen such a thing before, I've not seen many folks that provide a starting value and number of...