On Tue, Jan 17, 2012 at 11:44 AM, Net Newbie wrote:
>
> how to create a stored procedure having a list of values as input parameter?
Its not simple, but it can be done using a string parameter (e.g. "1,
2, 3, 4") and
creating a SQL string that you feed to EXECUTE STATEMENT.
> I need to retrieve
Hi,
Maybe someone will come up with a more elegant solution, but if not,
here's a simple trick.
Pass your list of values as a string, separating values with commas
(take care not to add extra spaces between values etc.). Suppose the
parameter name in the procedure is par_list and the string
"7
(my previous post appeared under another thread, as I did reply. I write
again to start new thread - sorry if someone gets 2 times).
how to create a stored procedure having a list of values as input parameter?
I need to retrieve result for query looking like
select field1, field2 from table1 whe
how to create a stored procedure having a list of values as input
parameter?
I need to retrieve result for query looking like
select field1, field2 from table1 where field3 in (1, 2, 3, 4);
is there a way to give list of values as input parameter? but sometimes
there could be just one value for