Number of rows returned by SQL query

[odumitre]

Can you please tell me if there is another way to get a specific number of rows from a query other than Top N?

How two application (two exe files) can comunicate between them in a workspace?

[kelfro]

I have one method for you.You can use a counter variable to do this

SQLDataReader dr = new SQLDataReader();
int counter = 0;
while ( dr.Read() )
{
counter +=;
}
Response.Write ( "Number of records is: " + counter );

Good luck !!

[XSI]

Why don't you use something like selecting the columns in SELECT clause, from the table in FROM clause, then providing the condition that the starting "N" rows are excluded in WHERE clause.

Example:

SELECT * FROM table_name
WHERE intPrimaryId > "n"