• Looks like I just figured out my own problem. Here's my solution. Just closing the loop.

    SELECT staffid,account FROM

    (select

    ROW_NUMBER() OVER(PARTITION BY staffid ORDER BY newid() ) AS RowID

    , * FROM #accounts ) InnerQ

    WHERE InnerQ.RowID <= 3