SQL Query with Variable (Parameter) in Excel

[knash (Ken Nash)]

Aleksander here is how I created did this in excel.

First create the stored procedure.

Then create a data source in excel. The command text calls the stored proc with variable.

Then define the parameter