最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

sql - Pass multiple cells as parameter in Excel query - Stack Overflow

programmeradmin5浏览0评论

let´s say I have a column with 10 unique ISINs in Excel. I want to pass these ISINs as 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 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

发布评论

评论列表(0)

  1. 暂无评论