From another board, someone linked to this code in an older post. After modifying & testing it, it looks like it works. Any issues with going this route rather than the MS route?
Products as x
( SELECT top 3
WHERE CategoryID = x.CategoryID
ORDER BY UnitsInStock desc