Posted on Tuesday, August 24, 2010 1:56 PM
SELECT TOP X COLUMNS FROM TABLE
X = variable
Assignment: show only 5 percent of a given range.....
Solution:
declare
@cntRows int
set
@cntRows = (select count(*) from tablename where date = getdate()) --set total
set @cntRows = (@cntRows * 0.05) --set 5 percent
select
top (@cntRows ) * from tablename where date = getdate() order by newid() --get 5 percent of random records!!!!!