Based on the error there are two options: Either you really have duplicate data or you haven't defined correct columns for the constraint.
If the idea is that a single
ProdID
can exist several times but not for the exact same
StartDate
then ensure that you create a key which contains both columns.An SQL statement could be something like:
ALTER TABLE EffectiveDate ADD PRIMARY KEY (ProdID, StartDate);