(will return random 50% of rows:) select * from table where sin(rand (datepart( ms , getDate())) * [rowIdenity]) > 0 (or to randomly sort:) select * from table order by sin(rand (datepart( ms , getDate())) * [rowIdenity])