Update query criteris check if laue present 1

[ali32j]

Hi All

i m using the following update query to update a table

INSERT INTO StrategyMonthly ( Name, ValueAll, CostAll, CostLDE, ValueLDE, [Month] )
SELECT StrategyCalcs.Name, StrategyCalcs.[Sum Of Net Value], StrategyCalcs.[Sum Of Cost], StrategyCalcs.SumCost, StrategyCalcs.Value, StrategyCalcs.[Billing Date By Month]
FROM StrategyCalcs;

I want it to check if [Month] already contains the month being entered (StrategyCalcs.[Billing Date By Month]) if so not to continue

is this possible? if so can anyone help?

Thanks

Ali

 

[PWise]

INSERT INTO StrategyMonthly ( Name, ValueAll, CostAll, CostLDE, ValueLDE, [Month] )
SELECT StrategyCalcs.Name, StrategyCalcs.[Sum Of Net Value], StrategyCalcs.[Sum Of Cost], StrategyCalcs.SumCost, StrategyCalcs.Value, StrategyCalcs.[Billing Date By Month]
FROM StrategyCalcs
left join StrategyMonthly
on StrategyMonthly.[month]=StrategyCalcs..[Billing Date By Month]
where StrategyMonthly.[month] is null

 

[ali32j]

Hi Pwise

Thankyou for your help works perfectly

Ali