I'm creating a stored procedure, that will accept a value from a user, check against one table and then copy corresponding rows from that table into another.
I've made the procedure, but ItemID remains all the same in all rows...
What do I do wrong here?
CREATE PROC up_name
SELECT ProdID, SerialNum, ItemNo
WHERE OrderID =