OPTIONS:

insert into tblTenderOptionPrices(fkidOption, fkidPriceLevel, crOptionCalcSelling, crOptionOverrideSelling, dtEffectiveDate, sgStdExtRef)

select idTenderOption, 1, 0, 0, getdate(), 'InsertedZeroPrice'  from tblTenderOptions

where idTenderOption not in (select fkidOption from tblTenderOptionPrices)



PACKAGES:

insert into tblTenderPackagePrices(fkidTenderPackage, fkidPriceLevel, crPackageCalcSelling, crPackageOverrideSelling, dtEffectiveDate)

select idTenderPackage, 1, 0, 0, getdate()  from tblTenderPackages

where idTenderPackage not in (select fkidTenderPackage from tblTenderPackagePrices)