| Subject | FIRST with input parameter | 
|---|---|
| Author | Roger Pullen | 
| Post date | 2005-06-29T14:21:34Z | 
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 doesnt like it if I try to put a parameter in place of the 3
SELECT FIRST :numberofarticles
Regards
Roger
            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 doesnt like it if I try to put a parameter in place of the 3
SELECT FIRST :numberofarticles
Regards
Roger