Using "select TOP" with parameter

[DRH192]

Is it possible to replace the value in the SQL with a parameter when working with select top queries. I want to beable to determin the number at run time and do not want to have to change the SQL to do this.

I know I could do it programatically but I dont want to start doing it this way if I can use a parameter in the select query.

Many thanks

 

[Golom]

Don't believe so. Parameters can be used to supply values to a query but not operators or predicates ... and TOP n is a predicate. You will probably have to modify the SQL in code.

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]