Hello  Jonathan.  I tried it, unfortunately, for part no XXX708, it selects 3 warehouses with no activity but there are 2 more with recent sales.

I would want XXX708 to not...

• This reply was modified 5 years, 3 months ago by  saintor1.
• This reply was modified 5 years, 3 months ago by  saintor1.

Oh!... I apologize for the duplicate, it didn't pass through the first time (gateway error). :o(  Please delete if possible.

• This reply was modified 5 years, 3 months ago by  saintor1.

The CTE version did the trick, thank you!

Also using "-PAST" instead of "PAST" did put it first

I copied and pasted from your reply and again, same result.

More specifically

Msg 207, Level 16, State 1, Line 41

Invalid column name 'DueDate'.

Msg 207, Level 16, State 1, Line 41

Invalid column...

• This reply was modified 5 years, 6 months ago by  saintor1.

I tried it and got

Invalid column name 'DueDate'.

Well I just did that - I used a temporary SQL table.   Maybe not the most sophisticated query but it works.   I thought that I could handle a temporary recordset...

Unfortunately there would be hundreds of values.

I tried to reference to rstADO as a regular recordset (not a string), as it was defined earlier in the code.   Didn't...

Ok *success*, I think that I figured out the use of table UDF...

SELECT   I.StockCode, I.Description, I.AlternateKey1 AS Family,
         I.LeadTime, I.Ebq, W.Warehouse, U.RET AS...

EDIT: Creation didn't work. On an hunch, removed WITH SCHEMABINDING and the creation of the function passed  Is it essential?  
EDIT...

I guess that I did something that should be a no-no... lol!    I remember having seen this RETURN TABLE instead of a variable in a SQLCENTRAL article a few...

Awesome (and learning)

Now getting the best of both worlds, I tried to alter the last tvf function (that was working) with other examples I found.   Basically a...

I read stuff about CROSS_APPLY that might be relevant (is it?)