LOGO KAMPANYALARI GUNLUK DOVIZ KURUNA GORE GUNCELLEME

UPDATE LG_119_CAMPAIGN SET VARIABLEDEFS1=(
SELECT  CASE WHEN RATES4>7.0 THEN 7.0 ELSE RATES4 END FROM LG_EXCHANGE_119 WITH(NOLOCK)
WHERE convert(varchar, EDATE, 104)= convert(varchar, getdate(), 104) AND CRTYPE=20
)