Random Selection

[MKH2001]

I have a problem (so my pshychiatrist tells me) that I have been looking at recently which is, of course, causing me some problems.

What I am looking to do is a report based on a data selection and report a 10% (or other percentage) of the result.

I am trying to use the random statement:

SELECT TOP 5000 Rnd([IMSV7_INLAI].[INSPNO]) AS Expr1, IMSV7_INLAI.STARTDTTM, IMSV7_INLAI.INSPNO INTO mktbl_InspectionAudit
FROM IMSV7_INLAI
ORDER BY Rnd([IMSV7_INLAI].[INSPNO]);

but obviously instead of Top 5000 I want to put in my percentage.

Any idea how to enter a percentage into a query such as this?

 

[Remou]

How about:
SELECT TOP 5 PERCENT ...

 

[MKH2001]

omg THAT simple =(

Never came across percentages in sql query before.

Many thanks Remou.