Let´s say I have a column with 10 unique ISIN values in Excel.
I want to pass these ISINs as an argument/parameter to query. I know it works with a single cell, where I put "?" in the query and the cell as parameter, but it doesn't work with multiple cells.
I want to filter the SELECT statement with a WHERE clause, where it returns only the rows with these ISINs. Something like this:
SELECT
e.ISINCode 'ISIN',
e.Equities_ShortName 'ShortName',
e.Equities_Name 'LongName'
FROM Equities e,
AND e.ISINCode IN (?)
Is it even possible to do it? We use Sybase SQL, or iSQL, I´m not too familiar with these databases, I just know a little bit of SQL coding. Thank you
