Hello, I have been charged with creating a parity tool that will compare the data in an Excel spreadsheet column (item numbers) with that of like data from our AS400. I know that I will connect using ODBC and will have to provide the users with the following options: Select by cell value, hardcoded value or parameter "?" Can I request multiple parameters in the SQL directly or will I have to call a function that incorporates the multiple params?

I was playing around with this:


Stored Procedure: GETITEMS uses the @item parameter in the where clause.

SELECT Item FROM TABLE
WHERE @Item IS NULL OR ITEM IN(SELECT * FROM SplitList(@Item,','))


Parameter Name: @Item
Parameter Value: =JOIN(Parameters!Item.Value,",")

I use Excel 2007 PC, the users have Excel on MAC's if that makes any difference.

Thanks for any help or direction in this matter.