input from user

[rose88]

I want to have input from user
so I did something like this:

declare @param int
SELECT dbo.tblOrders.MedicineNum
FROM dbo.tblOrders INNER JOIN
dbo.tblMedicine ON dbo.tblOrders.MedicineNum = dbo.tblMedicine.MedicineNum
GROUP BY dbo.tblOrders.MedicineNum
HAVING (COUNT(dbo.tblOrders.MedicineNum) > @param)[/color blue]

but it doesn't show me a box or anything to write an input!!!
can anyone help me with this?

 

[JoeAtWork]

SQL Server isn't like Access where you run an SQL Statement and a dialog pops up to ask for parameter values.

You have to write a front-end program (in .NET or some other programming language) to be a GUI for your users.

 

[TysonLPrice]

You could run it from Excel instaed of writing an application and get prompts from there.