I am trying to create a report that grabs the top 20 records from a table. The table contains data on 6 different machines,
so I am assuming that I need to loop six times and pass a variable to the query which indicates the machine id. I have tried creating an integer array that contains machine_id as an integer, and this is passed to the query. The machine_id array stores the following ids : 1600, 1800, 3600, 4800, 6000, and 6001.My problem is when looping through the query, the SELECT statement has to be invoked more than once... How can I append the records to the query and pass the array (machine_id) to the query? The machine id determines what data to run the query on ( the query uses the TOP keyword).
GFK