• I'm just using the NEWID() function as a way to create unique random numbers for each row. When you use RAND() in a query like this, it generates the same number for each row.

    This is just for illustration in this example. In real situations, the numeric measures come from the source and destination queries, and aren't random numbers.