ERP Nedir? | Türkiye'nin ERP Forum Platformu : view http://www.erpne.org/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 17 Apr 2026 21:34:05 +0000 Tue, 07 Jan 2014 15:14:36 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.10 360 www.erpne.org/RSS_post_feed.asp?TID=3673 <![CDATA[ERP Nedir? | Türkiye'nin ERP Forum Platformu]]> http://www.erpne.org/forum_images/logotype.png http://www.erpne.org/ <![CDATA[view : cvp için çok te?ekkürler ilk fyrsatta...]]> http://www.erpne.org/view_topic3673_post19659.html#19659 Yazar: huseyin_v2451
Konu: 3673
Gönderim Zamanı: 07 Ocak 2014 Saat 15:14

cvp için çok te?ekkürler ilk fyrsatta deneyece?im
iyi çaly?malar...
]]> Tue, 07 Jan 2014 15:14:36 +0000 http://www.erpne.org/view_topic3673_post19659.html#19659 <![CDATA[view : Selam,A?a?ydaki gibi yazmanyz...]]> http://www.erpne.org/view_topic3673_post19647.html#19647 Yazar: rifatgunduz
Konu: 3673
Gönderim Zamanı: 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
]]> Mon, 06 Jan 2014 18:00:57 +0000 http://www.erpne.org/view_topic3673_post19647.html#19647 <![CDATA[view : slm arkada?lar elimde bi view...]]> http://www.erpne.org/view_topic3673_post19646.html#19646 Yazar: huseyin_v2451
Konu: 3673
Gönderim Zamanı: 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]]> Mon, 06 Jan 2014 17:12:38 +0000 http://www.erpne.org/view_topic3673_post19646.html#19646