Limiting rows returned from a stored procedure

[oddball]

Is there a simple way of returning only five results from the following stored procedure (ie those 5 companies who registered most recently)

==========================================================

ALTER PROCEDURE GetNewestCompanies

AS

SELECT
CompanyName,
RegDate

FROM
Company

ORDER BY
RegDate DESC

===========================================================

cheers,

si

 

[sunila7]

Hi,

u can change the SQL like this to return 5 compnaies

SELECT TOP 5
CompanyName,
RegDate

FROM
Company

ORDER BY
RegDate DESC


Sunil

 

[foxdev]

Sunil's suggestion is best, but to be complete, an alternative is:

[tt]set rowcount 5[/tt]
--------------
Low Cost Prints:

http://www.lowcostprints.com

 

[oddball]

Cheers sunila7,

knew there must be a command to do it!