bosstan1@gmail.com wrote:
> try too switch CommandType from Text to StoredProcedure in dataset
> dialog box
>
>
> vetaldj wrote:
> > Hello,
> >
> > I have an issue with multivalue parameter. I need to pass it to stored
> > procedure. FE I have @parameter that can have multivalue. When I use
> > select statement in report it very easy:
> >
> > select * from table where col1 in (@parameter)
> >
> > But when I want to pass it to stored procedure
> > exec sp_test @parameter
> >
> > [
> > create procedure sp_test (@parameter as varchar(200) )
> > as
> > select * from table where col1 in (@parameter)
> > ]
> >
> > I got an error that sp has to many argument specifyed....
> > What i do wrong?