(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 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 input. so it should work also for select field1, field2 from table1 where field3 in (1); thank you.
