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