In theory yes but in reality possibly not. In the real StockItemMemo table there is a column for the last updated datetime so I'm just going to do a TOP...

I think you've misunderstood what I'm looking for.

Someone on another site has provided the below which is doing what I want:

DECLARE @title as VARCHAR(MAX) = 'Title:';

; WITH...

Unfortunately, that is giving the same result as my query above:

ItemID               SKU ...

The below is the part of the query shown above that looks up the title

(SELECT TOP 1 MemoText FROM StockItemMemo WHERE StockItemMemo.ItemID = StockItem.ItemId and MemoText like...

• This reply was modified 4 years, 2 months ago by  josh_marchant.
• This reply was modified 4 years, 2 months ago by  josh_marchant.