Hi,
Thank you for the quick tip.
I believe a follow up is in need.
In case the manager asks for a new batch of random customers after a while,
The "on the fly" GUID(NewID), although it is generated uniquely per run,
might produce some of the customers that were on the previous run.
Therefore I’d suggest to add a BIT type column (0,1) to monitor which customers were called,
so you could mark them up and exclude them from your next runs.
SELECT TOP 5 PERCENT *
FROM Data.SalesByCountry
WHERE Called = 0 -- 0 = not called, 1 = called
ORDER BY NEWID()
Make sure you update the [Called] column to '1'
for the customers you called.
A select with output/update query will do it at one go.