Limiting Number of Records Retrieved

[xterra]

Is there a way to only retrieve a specific number of records? For instance if I have something I know will retrieve 200 records and I only want to get the first 50.

Thanks,

Adam

 

[tlbroadbent]

Use SET rowcount 50 in you SQL script prior to the SELECT query. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln

 

[xterra]

Worked great!!! Thanks a bunch.

Adam