Wouldn't it be EXEC databasename.dbo.storedproc_name '$ChangeID$' '$Field2$' '$Field3$'
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of gok's Sent: Monday, August 22, 2011 11:23 PM To: [email protected] Subject: Re: How can I pass multiple input parameters in direct SQL Hi Ben, Thanks for response....I am really sorry that I haven't explained here properly....I trying to pass multiple input parameters from Direct SQl to stored proc EXEC databasename.dbo.storedproc name $"ChangeID"$ in the above execute condition is it possible to send multiple input parameters or does any one have any idea..... > -----Original Message----- > Benny Shell wrote: > > I'm a little confused.. The you can pass any number of parameters to the > stored procedure in the SQL statement you use to call it, ,just substitute > the field names in the text of the SQL call. > >> -----Original Message----- >> On Fri, Aug 19, 2011 at 10:49 PM, gok's <[email protected]> wrote: >> >> Hi ALL, >> ARServer 7.5 >> Database:SQL 2005 sp2 >> Windows NT >> >> I am trying to pass multiple input parameters to a stored procedure but >> is >> it possible to pass multiple parameters...can some one suggest me. >> >> Thanks >> G >> >> -- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
