INSERT INTO ItemDynamic 

(ItemID, StoreID, Quantity, QuantityCommitted, ReorderPoint, RestockLevel, TaxID, snapshotcost) 

SELECT itemid, 230, Quantity, QuantityCommitted, ReorderPoint, RestockLevel, TaxID, snapshotcost

from itemdynamic where storeID = 1001