insert into tblCONTSPRateHourTariff select allotRateHour.Id ,(select id FROM [dbo].[tblACCTSPContractTariff] where TariffName='MPS_FLAT_MINIVAN_247' and ContractDetailId=1021) ,(select TariffType FROM [dbo].[tblACCTSPContractTariff] where TariffName='MPS_FLAT_MINIVAN_247' and ContractDetailId=1021) from tblCONTAllotInventory allot join tblCONTSPRateHour allotRateHour on allot.Id=allotRateHour.AllotInventoryId --join tblCONTSPRateHourTariff rateHourTariff on allotRateHour.id=rateHourTariff.RateHourId join [tblCONTAllotInventSegment] allotSeg on allot.Id=allotSeg.AllotInventoryId join tblSYSASegment seg on allotSeg.SegmentId=seg.Id join tblCONTServiceProperty prop on allot.SPropertyId=prop.Id join tblCONTServiceProvider sp on sp.Id=prop.SPId where seg.Name='STORBIL-MPS' and sp.ContractId in (1021) and seg.SegmentId='ABC123'
and not exists (select * from [dbo].[tblACCTSPContractTariff] where TariffName = 'MPS_FLAT_MINIVAN_247')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)