Subject FIRST with input parameter
Author Roger Pullen
All

I have written a stored procedure that selects the first 3 items, what I am
trying to do now is allow the stored procedure to take an input of the
number of rows to select and use this to pull of x records.


Current sql:
SELECT FIRST 3


It doesn’t like it if I try to put a parameter in place of the 3
SELECT FIRST :numberofarticles


Regards

Roger