define a ari fan SQL query from a Cell Value in Excel

[peterhinton]

Hi All,

I populate a pivot table using some SQL,

the start of my code looks like:

DECLARE
 @CW INT, @CM INT, @CQ VARCHAR(4);

SET
 
 @CW=19;SET @CM = 5;SET @CQ ='QTR2'
SELECT
--CHOOSE BRANCH INFO TO USE AND FILTER IN PIVOT
SA
 
.BRANCHNO As' Branch No'
,
 
EU.[STORE NAME] As'Branch Name'
,
 
 
EU.COUNTRY

Where I declare the values for CW,CM,CQ I want that to reference Cells B1,C1,D1 respectively,

How can this be done, If it can be done that is ?

EDIT - TITLE GOT MESSED UP SOMEHOW LOL