Home Forums SQL Server 2005 T-SQL (SS2K5) How to return a certain percentage of rows (NOT TOP PERCENT QUESTION) RE: How to return a certain percentage of rows (NOT TOP PERCENT QUESTION)

  • create table #temp (customer varchar(15),number int)

    insert into #temp select'A',1

    insert into #temp select'B',1

    insert into #temp select'C',1

    insert into #temp select'D',1

    drop table #temp

    What is the expected results of selecting 25% of the above?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]