Passing Placeholder parameters from Excel Query Editor to SQL Stored Procedure

[MerlinJnr]

I have a number of reports in Excel that pull from SQL Server 2005 by calling Stored Procedures.

I use the {CALL [SP_Name] (?)} Syntax to do this.

When I hard input say '2007' as the parameter the command works fine, but when I leave the placeholder ? in, which is defined from a cell in a control sheet in Excel, it does not.

Can anyone advise how I can pass placeholder parameters through please.

Many thanks

 

[MerlinJnr]

I guess there is no one on this forum who can help on this......

 

[Anon_F]

I guess there is no one on this forum who can help on this......

Your correct.

 

[MerlinJnr]

Your correct.

So it would seem. Thanks

 

[Anon_F]

Have you thought of using google to see if that can help or a more specialized forum!

 

[MerlinJnr]

I have indeed tried, and am attempting to find a forum that I have posted on with a) a response b) where a response, then is it applicable.
Never mind. Take it easy....

 

[Madxgraphics]

HI MerlinJNr


There is somebody on here that might be abe to help you, but he is not on often....Not all of us are experienced in SQl and the likes...Patience pays..I'm sure somebody will be able to give you some sort of usefull help on here...

 

[MerlinJnr]

Thanks Mad. I'll hang in there