Parameter passing through Qlikview to SQL procedure
I have table named Inventory and it has data like as follows:
ID Product Warehouse Quantity
142
Green beans
NY
100
214
Peas
FL
200
825
Corn
NY
140
512
Lima beans
NY
180
491
Tomatoes
FL
80
379
Watermelon
FL
85
NULL
NULL
NULL
NULL
I made a Stored Procedure as follows:
CREATE PROCEDURE sp_GetInventory @location varchar(10) AS SELECT Product, Quantity FROM Inventory WHERE Warehouse = @location
When I execute it as:
Execute sp_GetInventory FL
It gives result as required by the stored proceduer given above.
CAn any one help me, I want to pass the parameter to the stored procedure through QlikView. such as if i want to place FL in input box so it gives data according FL with executing stored proceudre.