On Tue, Jan 17, 2012 at 11:44 AM, Net Newbie <[email protected]> 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 result for query looking like > > select field1, field2 from table1 where field3 in (1, 2, 3, 4); > Good luck, Ann
