BennyLinton
Registered User.
- Local time
- Yesterday, 16:36
- Joined
- Feb 21, 2014
- Messages
- 263
I am using the SQL below to successfully return a set of 10% of my total eligible, however I need to change this to 2% but it returns NO records... puzzled:
INSERT INTO Random_Temp ( indx, peopleId, audited )
SELECT TOP 10 PERCENT b.indx, b.peopleId, -1 AS audited
FROM dbo_Billing AS b
ORDER BY Rnd(-(1000*b.indx)*Time());
INSERT INTO Random_Temp ( indx, peopleId, audited )
SELECT TOP 10 PERCENT b.indx, b.peopleId, -1 AS audited
FROM dbo_Billing AS b
ORDER BY Rnd(-(1000*b.indx)*Time());