insert weights from PartPackage to PartAttribute where PartAttribute.field = 'weight' is null

Weight Insert for CURT Dev

use CurtDev

INSERT INTO PartAttribute (partID, value, field)
SELECT partID, weight, 'Weight'
FROM PartPackage
WHERE PartPackage.partID IN (
  			/*the group of partIDs to update*/
				SELECT partID
				FROM Part 
				WHERE partID NOT IN
					(SELECT partID 
					 FROM PartAttribute
					 WHERE field = Upper ('WEIGHT')))
					 order by partID