Results when Limit max rows retrieved in query panel

[Former Member]

Hi,

I have a question about the results in a Webi when you limit the rows retrieved.

I limit the query to 300 rows, how the Webi choose the 300 rows from for example 2000 total result of the query. I know that its not the first 300 rows because when i do the query direct in data base with a top 300 the results are different.  

Thanks

Jose

[Former Member]

WEBI will choose 300 rows from first 300 rows fetched by database .

Here you are not applying any order or top key word to query in database so in what ever order database wil fetch the rows the same order webi will display as 300 rows.

Thanks,
Swapnil

[amitrathi239]

Hi,

Might be Top function behave different  to limit number of rows in the webi.

Instead of Top 300 rows in the database,  restrict the rows limit in the database.Copy the webi report SQL and then run in the database.

See if records are matching or not.

Amit

[Former Member]

Thanks for you reply,

I did a "set rowcount 300" in sql and the result its different from the webi report. how can i restrict the limit in SQL server?