sql cümle uyarlama

[sevensuleyman]

SELECT
p.id as 'UrunID',
p.productCode as 'Urun-Kodu',
p.productName as 'UrunAdi',
p.barcode as 'Barcode',
p.mpn as 'Ürün Mpn'
from product as p
round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)  as 'fiyat1',
round((p.price2*(cast((p.kdv_id+100) as float)/100)),2)  as 'fiyat2',
round((p.price3*(cast((p.kdv_id+100) as float)/100)),2)  as 'fiyat3',

merhaba kolay gelsin ;

fiyat1 25 den küçükkse fiyat1*2+fiyat2
fiyat1 49 danküçükse fiyat1*1.40+fiyat2
fiyat1 500 den küçükse fiyat1*1.40+fiyat2 gibi devam etmekteidr.



bunu yukarıdaki sql cümlemizeuyarlamak istiyoruz. yazdırmak istediğimiz fiyat3 kısmıdır ...
üstatlar yardımcı olursasevinirim şimdiden teşkkürler


excellde kullandığum formül aşağıdaki gibidir.
If F >= 3000 Then v(i, 3) = (F * 1.25) + o
If F >= 1500 And F < 3000 Then v(i, 3) = (F * 1.3) + o
If F >= 500 And F < 1500 Then v(i, 3) = (F * 1.35) + o
If F >= 49 And F < 500 Then v(i, 3) = (F * 1.4) + o
If F >= 23 And F < 49 Then v(i, 3) = (F * 1.4) + o
If F > 0 And F < 23 Then v(i, 3) = (F * 2) + 5

 

[sevensuleyman]

düzeltmedir. ilk kodu yanlış kopyalamışız. lütfen bunu dikkae alalrak cevaplarsanız sevinirim

SELECT
p.id as 'UrunID',
p.productCode as 'Urun-Kodu',
p.productName as 'UrunAdi',
cast(p.quantity as text) as 'Ürün Adeti' ,
p.barcode as 'Barcode',
p.mpn as 'Ürün Mpn' ,
p.currencyType as 'ParaBirimi',
p.kdv_id as 'Kdv',
round((p.price1*(cast((p.kdv_id+100) as float)/100)),2) as 'fiyat1',
round((p.price2*(cast((p.kdv_id+100) as float)/100)),2) as 'fiyat2',

from product as p

 

[dost]

Merhaba,

Dosyanızı eklemediğiniz için deneme fırsatım olmadı.

Aşağıdaki kodu denersiniz.

SELECT
p.id as 'UrunID',
p.productCode as 'Urun-Kodu',
p.productName as 'UrunAdi',
cast(p.quantity as text) as 'Ürün Adeti' ,
p.barcode as 'Barcode',
p.mpn as 'Ürün Mpn' ,
p.currencyType as 'ParaBirimi',
p.kdv_id as 'Kdv',
round((p.price1*(cast((p.kdv_id+100) as float)/100)),2) as 'fiyat1',
round((p.price2*(cast((p.kdv_id+100) as float)/100)),2) as 'fiyat2',
Switch(
        fiyat1 < 23, (fiyat1*2)+fiyat2,
        fiyat1 < 500, (fiyat1*1.40)+fiyat2,
        fiyat1 < 1500, (fiyat1*1.35)+fiyat2,
        fiyat1 < 3000, (fiyat1*1.30)+fiyat2,
        (fiyat1*1.25)+fiyat2
          ) AS fiyat3
from product as p

 

[dost]

Merhaba,

Kodda problem olursa Swtich kısmını aşağıdaki şekilde değiştirip deneyin.

Switch(
         round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)< 23, (round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)*2)+ round((p.price2*  (cast((p.kdv_id+100) as float)/100)),2),
         round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)< 500, (round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)*1.40)+ round((p.price2*(cast((p.kdv_id+100) as float)/100)),2),
         round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)< 1500, (round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)*1.35)+ round((p.price2*(cast((p.kdv_id+100) as float)/100)),2),
         round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)< 3000, (round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)*1.30)+ round((p.price2*(cast((p.kdv_id+100) as float)/100)),2),
         (round((p.price1*(cast((p.kdv_id+100) as float)/100)),2)*1.25)+ round((p.price2*(cast((p.kdv_id+100) as float)/100)),2)
) AS fiyat3