based on following SQL Script which is join with other table, May i know how to define and set value parameter ?
Kindly advise, thank you
SELECT
A.INV_TYPE,
A.INV_ID,
A.INV_SHORTDESC,
A.INV_UNIT,
B.INV_LOCATION,
B.INV_BIN,
ISNULL(B.INV_QTY,0) AS INV_QTY
FROM CIMProRPT01.dbo.OTH_INV_DETAILS A
LEFT JOIN CIMProRPT01.dbo.OTH_INV_QTY_LOC B
ON A.INV_ID = B.INV_ID
WHERE 1=1
AND A.INV_TYPE =@INV_TYPE
AND A.INV_ID = @INV_ID
ORDER BY A.INV_TYPE,A.INV_ID
Member
53 Points
192 Posts
How to define and set value parameters in sql data source ?
Feb 24, 2014 02:05 AM|caulson|LINK
Dear All,
based on following SQL Script which is join with other table, May i know how to define and set value parameter ?
Kindly advise, thank you
All-Star
52673 Points
15717 Posts
Re: How to define and set value parameters in sql data source ?
Feb 24, 2014 02:16 AM|oned_gk|LINK
You can set value directly, like
Or you can get value from control, querystring, session etc like
Or use code behind
To test your query simply type a value for each parameter
Suwandi - Non Graduate Programmer