Restrict The Number Of Records From Query

Hi,
ive a table of over 90,000 records . is ther any method for restricting the number of records returned by a SELECT query
i want to implement a query system which will give me the first 50 records, next 50 ,... and so on
can ne body help ?Originally posted by baburajv
Hi,

ive a table of over 90,000 records . is ther any method for restricting the number of records returned by a SELECT query

i want to implement a query system which will give me the first 50 records, next 50 ,... and so on

can ne body help ?

select top 50 from table_name|||SELECT TOP 50 FROM TABLE_NAME

WILL RETURN THE TOP 50 ROWS FROM THE TABLE

HOW CAN I RETRIEVE THE NEXT 50 ROWS|||Originally posted by baburajv
SELECT TOP 50 FROM TABLE_NAME

WILL RETURN THE TOP 50 ROWS FROM THE TABLE

HOW CAN I RETRIEVE THE NEXT 50 ROWS

I think then u need to use temperory tables for it.|||select top NUMBER_OF_ROWS *
from table
where column NOT IN
(select top BEGIN_AT column
from table)

Restrict Date Selection

Hi All
I have a From and a To Date in a SQL Server 2005 Reporting Services Report.
How do I go about restricting the To Date so that is can't be less than the
From Date and also so the To Date is no more than 12 months greater than the
From Date?
ThanksOn Jun 24, 10:24 pm, David <D...@.discussions.microsoft.com> wrote:
> Hi All
> I have a From and a To Date in a SQL Server 2005 Reporting Services Report.
> How do I go about restricting the To Date so that is can't be less than the
> From Date and also so the To Date is no more than 12 months greater than the
> From Date?
> Thanks
If my memory servers me correctly, I think the only way to have this
kind of control of granularity (limiting dates), you will need to
create custom report parameters based on a dataset(s). Sorry that I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant