If you ask in the Database Development forum some DB guru may be aware of the best way to do this. With my less-than-complete knowledge of SQL I would probably just create a query that took one ID and execute it multiple times. If you do that make sure you explicitly open the connection first and close it afterwards. If you don't do that it will be closed and reopened between each pair of calls, which will slow it down considerably. To access the Connection property of the TableAdapter you'll have to make it Public in the DataSet designer.