Good day,

I am a newbie when in comes to SQL Server.

I don't know how to do this using SQL pass-through.

I would like to be enable the user to choose several items from a grid or listbox. Based on the items choosen, gather the inventory on hand (QtyOnHand).

Let's say that the inventory on hand (QtyOnHand) field is found in the Item Master file.

Thanks very much in advance.