Hi,
I'm trying to create a stored proc that accepts a filter parameter like "replies > 0". I know it can be done with putting the query in an exec function, but my select query is about 20 lines long. It would be a bit unhandy to put it all in between quotes. Is there another way to do this?
Thanks for your help!
Nander.
I'm trying to create a stored proc that accepts a filter parameter like "replies > 0". I know it can be done with putting the query in an exec function, but my select query is about 20 lines long. It would be a bit unhandy to put it all in between quotes. Is there another way to do this?
Thanks for your help!
Nander.