The problem in outline A simple expression can assign a random order or row number to a set of records.  The following example assigns a random decimal value between 0 and 1 to each row in a set: CAST(RANK() OVER (ORDER … Continue reading →