Retrieving the top number results using a local variable 2

[cplsplsprogrammer]

Hello all,

I am trying to write a stored procedure which takes in a number as input and retrieves the top number of results. I wrote the following code but it is not working. Can anyone please tell me what I am doing wrong or what is the correct procedure to write the statement.

Create Procedure records (@count int not null)
as
begin
select top @count id, type, evtime from customerTable
end
GO

Thanks.

 

[sunila7]

Have a look at this thread thread183-1097236.

Sunil

 

[Catadmin]

Hey, that's a nifty solution!

Thanks, sunila7!



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[cplsplsprogrammer]

Thank You for a quick answer sunil

Ram