view
Nereden Yazdırıldığı: ERP Nedir? | Türkiye'nin ERP Forum Platformu
Kategori: ERP Temel Paketler
Forum Adı: ERP Rapor Modülü
Forum Tanımlaması: Rapor Modülü İle İlgili Bilgiler ve Sorular İçin...
URL: http://www.erpne.org/forum_posts.asp?TID=3673
Tarih: 29 Mart 2025 Saat 17:07
Program Versiyonu: Web Wiz Forums 11.10 - http://www.webwizforums.com
Konu: view
Mesajı Yazan: huseyin_v2451
Konu: view
Mesaj Tarihi: 06 Ocak 2014 Saat 17:12
slm arkada?lar elimde bi view var de?i?iklikler yaptym ancak bi türlü çaly?tyramadym hata veriyor.ben sadece stok kodu kysytlaryny de?i?tirmek istiyorum ancak hata veriyor yeni stok kodlary 00001 den 00012 ye kadar.
yardymcy olursanyz çok sevinirim.
SELECT STHAR_TARIH AS TARIH,SUM(CASE WHEN STOK_KODU IN ('00001’,’00002’,’ 00003’)
THEN STHAR_GCMIK ELSE 0 END) AS BONFILE, SUM (CASE WHEN STOK_KODU LIKE '00008 ' THEN STHAR_GCMIK ELSE 0 END) AS PILIC,
SUM(CASE WHEN STOK_KODU LIKE '00004' THEN STHAR_GCMIK ELSE 0 END) AS CIGER,
SUM(CASE WHEN STOK_KODU LIKE '00007' THEN STHAR_GCMIK ELSE 0 END) AS KANAT, SUM(CASE WHEN STOK_KODU IN '00005' THEN STHAR_GCMIK ELSE 0 END) AS BUT,
SUM(CASE WHEN STOK_KODU LIKE'00010' THEN STHAR_GCMIK ELSE 0 END) AS BAGET,
SUM(CASE WHEN STOK_KODU IN '00006' THEN STHAR_GCMIK ELSE 0 END) AS PIRZOLA,
SUM(CASE WHEN STOK_KODU LIKE '00001' THEN STHAR_GCMIK ELSE 0 END) AS YEMEKLIK,
SUM(CASE WHEN STOK_KODU LIKE '00012' THEN STHAR_GCMIK ELSE 0 END) AS KEMIK,
SUM(CASE WHEN STOK_KODU IN ('00001','00002', '00003', '00004', '00005', '00006', '00007', '00008', '00009', '00010', '00011', '00012') THEN STHAR_GCMIK ELSE 0 END) AS TOPLAMKG,
SUM(CASE WHEN STOK_KODU IN ('00001','00002', '00003', '00004', '00005', '00006', '00007', '00008', '00009', '00010', '00011', '00012') THEN (STHAR_GCMIK * STHAR_NF)* 1.08 ELSE 0 END) AS TOPLAMTL,
SUM(CASE WHEN STOK_KODU IN ('00001','00002', '00003', '00004', '00005', '00006', '00007', '00008', '00009', '00010', '00011', '00012')
THEN (STHAR_GCMIK * STHAR_NF) * 1.08 ELSE 0 END) / SUM(CASE WHEN STOK_KODU IN ('00001','00002', '00003', '00004', '00005', '00006', '00007', '00008', '00009', '00010', '00011', '00012')
THEN STHAR_GCMIK ELSE 0 END) AS OTRFYT
FROM dbo.TBLSTHAR
-------------------------------------------------
view in orjinali böyleydi;
SELECT STHAR_TARIH AS TARIH, SUM(CASE WHEN STOK_KODU IN ('152-01-001', '152-01-999', '152-01-005', '152-01-006', '152-01-007')
THEN STHAR_GCMIK ELSE 0 END) AS BONFILE, SUM(CASE WHEN STOK_KODU LIKE '152-01-002' THEN STHAR_GCMIK ELSE 0 END) AS PILIC,
SUM(CASE WHEN STOK_KODU LIKE '153-01-001' THEN STHAR_GCMIK ELSE 0 END) AS CIGER,
SUM(CASE WHEN STOK_KODU LIKE '152-01-003' THEN STHAR_GCMIK ELSE 0 END) AS KANAT, SUM(CASE WHEN STOK_KODU IN ('152-01-012',
'152-01-004') THEN STHAR_GCMIK ELSE 0 END) AS BUT, SUM(CASE WHEN STOK_KODU LIKE '152-01-008' THEN STHAR_GCMIK ELSE 0 END)
AS BAGET, SUM(CASE WHEN STOK_KODU IN ('152-01-009', '152-01-013') THEN STHAR_GCMIK ELSE 0 END) AS PIRZOLA,
SUM(CASE WHEN STOK_KODU LIKE '152-01-010' THEN STHAR_GCMIK ELSE 0 END) AS YEMEKLIK,
SUM(CASE WHEN STOK_KODU LIKE '152-01-011' THEN STHAR_GCMIK ELSE 0 END) AS KENIK,
SUM(CASE WHEN STOK_KODU LIKE '152-01-014' THEN STHAR_GCMIK ELSE 0 END) AS DONER, SUM(CASE WHEN STOK_KODU IN ('152-01-014',
'152-01-011', '152-01-010', '152-01-009', '152-01-013', '152-01-008', '152-01-012', '152-01-004', '152-01-003', '153-01-001', '152-01-002', '152-01-001',
'152-01-999', '152-01-005', '152-01-006', '152-01-007') THEN STHAR_GCMIK ELSE 0 END) AS TOPLAMKG,
SUM(CASE WHEN STOK_KODU IN ('152-01-014', '152-01-011', '152-01-010', '152-01-009', '152-01-013', '152-01-008', '152-01-012', '152-01-004',
'152-01-003', '153-01-001', '152-01-002', '152-01-001', '152-01-999', '152-01-005', '152-01-006', '152-01-007') THEN (STHAR_GCMIK * STHAR_NF)
* 1.08 ELSE 0 END) AS TOPLAMTL, SUM(CASE WHEN STOK_KODU IN ('152-01-014', '152-01-011', '152-01-010', '152-01-009', '152-01-013',
'152-01-008', '152-01-012', '152-01-004', '152-01-003', '153-01-001', '152-01-002', '152-01-001', '152-01-999', '152-01-005', '152-01-006', '152-01-007')
THEN (STHAR_GCMIK * STHAR_NF) * 1.08 ELSE 0 END) / SUM(CASE WHEN STOK_KODU IN ('152-01-014', '152-01-011', '152-01-010', '152-01-009',
'152-01-013', '152-01-008', '152-01-012', '152-01-004', '152-01-003', '153-01-001', '152-01-002', '152-01-001', '152-01-999', '152-01-005', '152-01-006',
'152-01-007') THEN STHAR_GCMIK ELSE 0 END) AS OTRFYT
FROM dbo.TBLSTHAR
WHERE (STHAR_GCKOD = 'C') AND (STHAR_HTUR = 'J') AND (STHAR_ACIKLAMA NOT IN ('900-001', '900-002', '900-003'))
GROUP BY STHAR_TARIH
-------------
Hüseyin_v2451
|
Cevaplar:
Mesajı Yazan: rifatgunduz
Mesaj Tarihi: 06 Ocak 2014 Saat 18:00
|
Selam, A?a?ydaki gibi yazmanyz gerekmektedir.
SELECT STHAR_TARIH AS TARIH, SUM(CASE WHEN STOK_KODU IN ('00001','00002',' 00003') THEN STHAR_GCMIK ELSE 0 END) AS BONFILE, SUM(CASE WHEN STOK_KODU ='00008' THEN STHAR_GCMIK ELSE 0 END) AS PILIC, SUM(CASE WHEN STOK_KODU ='00004' THEN STHAR_GCMIK ELSE 0 END) AS CIGER, SUM(CASE WHEN STOK_KODU ='00007' THEN STHAR_GCMIK ELSE 0 END) AS KANAT, SUM(CASE WHEN STOK_KODU ='00005' THEN STHAR_GCMIK ELSE 0 END) AS BUT, SUM(CASE WHEN STOK_KODU ='00010' THEN STHAR_GCMIK ELSE 0 END) AS BAGET, SUM(CASE WHEN STOK_KODU ='00006' THEN STHAR_GCMIK ELSE 0 END) AS PIRZOLA, SUM(CASE WHEN STOK_KODU ='00001' THEN STHAR_GCMIK ELSE 0 END) AS YEMEKLIK, SUM(CASE WHEN STOK_KODU ='00012' THEN STHAR_GCMIK ELSE 0 END) AS KEMIK, SUM(CASE WHEN STOK_KODU IN ('00001','00002', '00003', '00004', '00005', '00006', '00007', '00008', '00009', '00010', '00011', '00012') THEN STHAR_GCMIK ELSE 0 END) AS TOPLAMKG, SUM(CASE WHEN STOK_KODU IN ('00001','00002', '00003', '00004', '00005', '00006', '00007', '00008', '00009', '00010', '00011', '00012') THEN (STHAR_GCMIK * STHAR_NF)* 1.08 ELSE 0 END) AS TOPLAMTL, SUM(CASE WHEN STOK_KODU IN ('00001','00002', '00003', '00004', '00005', '00006', '00007', '00008', '00009', '00010', '00011', '00012') THEN (STHAR_GCMIK * STHAR_NF) * 1.08 ELSE 0 END) / SUM(CASE WHEN STOK_KODU IN ('00001','00002', '00003', '00004', '00005', '00006', '00007', '00008', '00009', '00010', '00011', '00012') THEN STHAR_GCMIK ELSE 0 END) AS OTRFYT FROM dbo.TBLSTHAR GROUP BY STHAR_TARIH
-------------
Rifat Gündüz
www.netsis.com.tr
|
Mesajı Yazan: huseyin_v2451
Mesaj Tarihi: 07 Ocak 2014 Saat 15:14
cvp için çok te?ekkürler ilk fyrsatta deneyece?im
iyi çaly?malar...
-------------
Hüseyin_v2451
|
|