Charles Baldo
asked on
Multiple Parameters in Query
Hello,
I am using SQL Reporting Services 2000 with Oracle database.
I need to pass in a parameter that will have 1 to many values.
The ORACLE SQL looks like this
SELECT
i.J_no,
l.assaynumber
FROM
instrument i
WHERE
i.J_no IN('34000701','34000702', ...list of many values ...) //..... many possible values here
and assaynumber IN(310,344,501 ...list of many values ...) //.....many possible values here)
I tried something like this
WHERE
i.J_no IN( :JVALUES ) where :JVALUES = '34000701','340002702','34 0000791'
but that did not work
Thank You
Chuck
I am using SQL Reporting Services 2000 with Oracle database.
I need to pass in a parameter that will have 1 to many values.
The ORACLE SQL looks like this
SELECT
i.J_no,
l.assaynumber
FROM
instrument i
WHERE
i.J_no IN('34000701','34000702', ...list of many values ...) //..... many possible values here
and assaynumber IN(310,344,501 ...list of many values ...) //.....many possible values here)
I tried something like this
WHERE
i.J_no IN( :JVALUES ) where :JVALUES = '34000701','340002702','34
but that did not work
Thank You
Chuck
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks both for the comments. Unfortunatly This cant be done in my situation.
I did try jimhorn suggestion but did not work. Derricks would work and I thought of that however I am in an FDA Validated environment. Creating a new table would be about as simple as getting the Pope to say "Priests can Marry".
So I am going to use a data grid and fill it. They can export the grid to excel and do what the want with it.
Thanks
Chuck
I did try jimhorn suggestion but did not work. Derricks would work and I thought of that however I am in an FDA Validated environment. Creating a new table would be about as simple as getting the Pope to say "Priests can Marry".
So I am going to use a data grid and fill it. They can export the grid to excel and do what the want with it.
Thanks
Chuck
ASKER
Thanks for the input, but it is a string, I did try the other field assaynumber without quotes because it is numeric.
Thanks
Chuck