how do I get SQL to print 40000 records at a time

[shaan1980]

Can I get a page wise action from SQL to print a certain number of records at a time ?

[Nutter]

SELECT field FROM table LIMIT 40000

Is that what you're asking? 40,000 seems like a lot to show one one page, I usually do a LIMIT between 5 and 25.

[shaan1980]

limit doesn't seem to work

I'm querying a sybase database.

my query yields 80000 rows I would like my query to display 40000 at a time

[aspdaddy]

Have you tried:
SET ROWCOUNT 40000

[shaan1980]

thats not what I am looking for

I want to to be able to see 40000 rows at a time off a 800000 data pull so that I can copy and paste in excel

[carguy84]

select top 40000
from table
where id > 0
order by id ASC

[aspdaddy]

I dont believe sybase supports top, limit etc. There are various workarounds on the sybase faq's.

Or just do it on the client.