view

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

cvp için çok te?ekkürler ilk fyrsatta deneyece?im
iyi çaly?malar...