"Roji. P. Thomas" <lazydragon@nowhere.com> wrote in message
news:%23nPdbqgiEHA.1644@tk2msftngp13.phx.gbl...
> > I'd like to be abe to dynamically build a tsql command to execute a
stored
> > procedure that takes parameters. Is this possible?
>
> YES :)
>
> --
> Roji. P. Thomas
> Net Asset Management
> https://www.netassetmanagement.com
>
>
> "Russ Ferrill" <rferrill@paracominc.com> wrote in message
> news:IkKWc.12845$Ib1.6074@newssvr22.news.prodigy.com...
> > I'd like to be abe to dynamically build a tsql command to execute a
stored
> > procedure that takes parameters. Is this possible?
> >
> >
>
>

> I'd like to be abe to dynamically build a tsql command to execute a stored
> procedure that takes parameters. Is this possible?

"Russ Ferrill" <rferrill@paracominc.com> wrote in message
news:IkKWc.12845$Ib1.6074@newssvr22.news.prodigy.com...
> I'd like to be abe to dynamically build a tsql command to execute a stored
> procedure that takes parameters. Is this possible?
>
>

"Russ Ferrill" <rferrill@paracominc.com> wrote in message
news:PVMWc.12872$HS1.12126@newssvr22.news.prodigy.com...
> I've looked at the discussion of the execute command in BOL but it says
> nothing about passing parameters. I would like to use:
> EXEC ( @spname @parm1, @parm2 OUTPUT ) where @spname is the name of the
> stored procedure, @parm1 is an input parameter and @parm2 is an output
> parameter. When I try this I get an error saying that I need to declare
> @parm1, which I have done prior to executing the statment. If I use the
same
> command with the actual name of the stored procedure in place of @spname
it
> works just fine, but I really need to be able to select the procedure
> dynamically. If there is a way to do this I would greatly appreciate some
> suggestions. Thanks very much.
>
> Russ
> "Roji. P. Thomas" <lazydragon@nowhere.com> wrote in message
> news:%23nPdbqgiEHA.1644@tk2msftngp13.phx.gbl...
> > > I'd like to be abe to dynamically build a tsql command to execute a
> stored
> > > procedure that takes parameters. Is this possible?
> >
> > YES :)
> >
> > --
> > Roji. P. Thomas
> > Net Asset Management
> > https://www.netassetmanagement.com
> >
> >
> > "Russ Ferrill" <rferrill@paracominc.com> wrote in message
> > news:IkKWc.12845$Ib1.6074@newssvr22.news.prodigy.com...
> > > I'd like to be abe to dynamically build a tsql command to execute a
> stored
> > > procedure that takes parameters. Is this possible?
> > >
> > >
> >
> >
>
>