Hello!



What about "SELECT TOP x * FROM <yourtable>" ?



Hakan



-----Ursprungligt meddelande-----

Från: Brooks_Piggott@D... [mailto:Brooks_Piggott@D...]

Skickat: den 17 september 2001 17:09

Till: ASP Databases

Ämne: [asp_databases] RE: Returning x Number of Rows SQL





"SELECT * FROM TABLE WHERE rownum <= x"





-----Original Message-----

From: James Kenney [mailto:JEK@m...]

Sent: Monday, September 17, 2001 9:58 AM

To: ASP Databases

Subject: [asp_databases] RE: Returning x Number of Rows SQL





Why not rs.movenext ten times



-----Original Message-----

From: Tony Yates [mailto:tony.yates@b...]

Sent: Monday, September 17, 2001 11:54 AM

To: ASP Databases

Subject: [asp_databases] Returning x Number of Rows SQL





I am trying to return x number of rows from a database query



eg



"SELECT * FROM TABLE " <<where record count = x>>



Regards

Tony