Thanks Sergey.

Now if I can just use some cursors :-)

>Try

>DECLARE @RecCount int
>SET  @RecCount = 50000 - < # of records in previous 2 groups >
>SELECT TOP (@RecCount) 
>  FROM mytable 
>  WHERE < record does not belong to 2 previous groups >
>  ORDER BY NewID()
>

>
>>
>>I have a task
>>
>>I want to select a list of people from my database.
>>
>>Total number to be selected 50000
>>
>>including all of two groups.
>>
>>Group 1 people who have joined 6 to 12 months ago.
>>
>>and
>>
>>Group 2 people who have previously paid
>>
>>so I imagine the group1 and group 2 will come to about 20000.
>>
>>How can I select a random selection of the rest.
>>
>>Any thoughts .
>>
>>Thanks
>>
>>Nick