Any way to call SP with dynamically determined param?

Topics: Developer Forum, User Forum
Dec 20, 2011 at 5:43 PM

Hi,

 

Regular call to SP works great

I'd like to create an action which can pass attributes of current cell for further Rowset Action

I wonder if it's possible to call SP and pass param something like:

 

'call SQLQuery.ExecuteSql(    "Provider= Sqlncli10;server=localhost;database=Test;trusted_connection=yes"    ,"exec usp_OLAPTest ASSP.ASStoredProcs.FindCurrentMembers.FindCurrentTuple()")'

or maybe there is ome workaround, otherwise it seems that I'd have to invoke this call from Excel VBA macro

Many Thanx

S