I need to write a stored proc that takes in a list of transaction codes and should only return those transactions where the code was specified in the list. From what I can tell you can't pass character arrays in to stored procs. How would I accomplish this.
My SQL statement might look like this...
Select * from transaction_table where transaction_code in ('a', 'b', 'g', 'k')
Those values a, b, g, and k could be anything and any number of codes. For example it could be h, m, s, t, u, and z. Anything!
How do I get these codes into the SP and ultimately into the SQL statement?