Creating reports and dashboards | Stimulsoft community forum

Posted: **Thu Jun 28, 2012 2:52 pm**

Hi,

I would like to pass value like '7002', '6997' into sql statement using in statement like following:

select * from users where id in (@Ids)

the @Ids value looks like '7002', '6997'

Please help!

Thanks
Alan

Posted: **Fri Jun 29, 2012 1:34 am**

Hello, Alan.

wangxianlg wrote:I would like to pass value like '7002', '6997' into sql statement using in statement like following:

select * from users where id in (@Ids)

the @Ids value looks like '7002', '6997'

We don't support list parameters in SQL query but you could use a variable of type string.

Code: Select all

select ... from ... where id in ({var1})

Where var1 = "'7002', '6997'"

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Pass value into sql in statement

Pass value into sql in statement

Pass value into sql in statement