Random select statement from existing results...

[lennym]

I need to perform a select statement where I select a 4% random sample of the results of a query. EG: I select a group of records from a table based on a date range and then I want to select a random 4% sample of the results. Does anyone have any suggestions for this?

Thanks muchly.

 

[Cagliostro]

declare @x integer
set @x = 10000 * rand()
---getting a four digit number
set @x = @x % 10
---setting it to < 10, also a random
select * from OneTable where OneRow = @x
John Fill