How do I create a 'from' 'to' in the Command parameter?

sample of queryin command:
,D.Dia
,D._Session_
,D._Modified_
,D._Status_
,D._Created_

FROM dbo."Ventas en Pesos" A
INNER JOIN dbo.Dim_Categoria B
ON A.Dim_Category_dKey = B.Dim_Category_dKey  
INNER JOIN Dim_Geografica C
ON A.Dim_Geografica_dKey = C.Dim_Geografica_dKey
INNER JOIN Dim_Tiempo D
ON A.Dim_Tiempo_dKey = D.Dim_Tiempo_dKey

WHERE C.Compania ={?Compania}
AND C.Region ={?Region}
AND C.Tienda = {?Tienda}
AND B.Area = {?Area}
AND B."Nivel Proceso" = {?Nivel Proceso}
AND B.Categoria = {?Categoria}
AND FROM D.Semana={?Semana}
TO D.Semana={?Semana}

What is the proper syntax and how do I setup the command prompt parameter for

AND FROM D.Semana={?Semana}
TO D.Semana={?Semana}

garyjgsAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
WHat do you mean NAME?
If you mean the popup that says NAME it wants you to give the parameter a NAME

mlmcc
0
 
mlmccCommented:

Is that a rnge parameter?
D.Semana IN {?Semana}

Otherwise use a start and end parameters

AND D.Semana >={ ?Start}
AND D.Semana< ={?End}

mlmcc

0
 
garyjgsAuthor Commented:
That did not want to work.  When I create the parameter on the command prompt, what Name is it looking for?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.