Re: How to limit rows selected?

Arun Jamwal wrote: > What's the optimum way to extract say, 50 , rows from > say, 100 customer data tables - the table names are not > known until runtime, ie, a separate table contains the > names of these 100 customer data tables? Each customer > data table may contain 1000+ records/rows. Look up the 'set rowcount N' option in your Transact SQL User's Guide or Reference Manual. -am