SQL can I update a table with an array?

[Starlitnight]

Bascially I want to UPDATE a particular column



Essentially I want to do the following:



ALTER PROCEDURE WriteStockStatus

(@asin varchar(10), @asinStockStatus varchar(15))

AS

UPDATE OnSale

SET StockStatus=@asinStockStatus

WHERE ASIN=@asin



Ok, but, I don’t want to have to call this thing 16 times to update 16 rows.

Is there a way I can pass the two variables as a table or two arrays or something?

 

[Remou]

Perhaps you are looking for forum961? This is the Microsoft Access Jet SQL forum.