Passing Placeholder parameters from Excel Query Editor to SQL Stored Procedure

MerlinJnr

MerlinJnr

Joined
Nov 26, 2008
Messages
5
Reaction score
0
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
 
Have you thought of using google to see if that can help or a more specialized forum!
 
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....
 
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...
 
Back
Top