declare @id_part decimal
set @id_part = 19
declare @count decimal
set @count = (select count(*) from comp_candidates where id_part=@id_part)
declare @winer decimal
set @winer = CEILING(rand()*@count)
print @winer
select nn=(select count(c1.id) from comp_candidates c1 inner join users u1 on c1.id_user=u1.id where c1.id_part = @id_part and  c1.id <= c.id), c.id_user,c.id_part,c.date,u.* into #tt from comp_candidates c inner join users u on c.id_user=u.id where c.id_part = @id_part
select * from #tt where nn=@winer