Wednesday, March 28, 2012

Parameter lists

In my data set I want to use a where clause with IN. E.g where name in (
'a', 'b', 'c')
But I don't want to hard code the list I want the user to enter it as a
parameter. Does SSRS support parameter lists?
where name in ( @.names )
--
McGeeky
http://mcgeeky.blogspot.comI am aifraid, since now NO, but there will be an option in SQL Server 2005.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
news:uK5sv3xdFHA.2880@.TK2MSFTNGP10.phx.gbl...
> In my data set I want to use a where clause with IN. E.g where name in (
> 'a', 'b', 'c')
> But I don't want to hard code the list I want the user to enter it as a
> parameter. Does SSRS support parameter lists?
> where name in ( @.names )
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>sql

No comments:

Post a Comment