Is there a way to limit the number of rows returned from a reporting services query
as in my query will return 500 rows but i only want the 1st 5 rows.
define number of rows returned from query
Hot Topic
- Problems migrating DTS package
- SQL Variables and Performance
- Attribute Relationships
- Studio 2005 Sql environment?
- SQL Server 2005 CTP Release Candidate Sept - unexpected failure during setup wizard
- FTP guaranteed delivery
- How to impersonate the user and send those credentials?
- Dynamically edit DataSet
- Making "incremental" updates to a data warerhouse
- uploading images to sql database using Visual Basic 6
SQL Server
- Batch Updation
- Parameter Information cannot be derived from SQL statements with sub-select queries
- best approach
- If-structure
- After Install of 2005 still 2000 Engine!
- [Time].&[2007].&[2] vs.[Time].[2007].[SEMI2]
- Script Component task, values such as "000-00-00" to smalldatetime field
- Need Reporing Server Options in VS 2005
- Express cannot convert different data types automaticly????
- Please help me! How do you change the default server in Visual C# Express?
define number of rows returned from query
Saravanan_article
right after the select you would use "TOP 5". So it would look something like
select top 5 * from table_name