title: Query to randomly select from a table without repeating selection
body: <p>I have two tables: <code>[employee]</code> and <code>[task]</code> and I want to assign 5 tasks from the <code>task</code> table per <code>employee</code> into a tracking table. The assignment needs to be random and each selection should exclude those tasks already selected.</p>