Convert Hatasi

Msg 245, Level 16, State 1, Line 15

Conversion failed when converting the varchar value 'A' to data type int.

Warning: Null value is eliminated by an aggregate or other SET operation.

--USE [KORMETAL09]

--GO

--/****** Object:  View [dbo].[zKORMETAL_JANT_YONETIM_PSH]    Script Date: 04/21/2009 11:26:27 ******/

--SET ANSI_NULLS ON

--GO

--SET QUOTED_IDENTIFIER ON

--GO

--CREATE   VIEW [dbo].[zKORMETAL_JANT_YONETIM_PSH]

--AS

SELECT SUBSTRING(MAMUL_KODU,3,9) AS STOK_KODU,MAMUL_KODU AS YT_STOK_KODU,HAM_KODU,STOK_ADI,

      ---DEPOLAR

    isnull((SELECT SUM(TOP_GIRIS_MIK)-SUM(TOP_CIKIS_MIK) FROM TBLSTOKPH

                  WHERE DEPO_KODU=145 AND STOK_KODU=SUBSTRING(MAMUL_KODU,3,9)

                  ),0) AS DEPOBAKIYE_145,

      isnull((SELECT SUM(TOP_GIRIS_MIK)-SUM(TOP_CIKIS_MIK) FROM TBLSTOKPH

                  WHERE DEPO_KODU=130 AND STOK_KODU='YT'+SUBSTRING(MAMUL_KODU,3,9)

                  ),0) AS DEPOBAKIYE_130,

      isnull((SELECT SUM(TOP_GIRIS_MIK)-SUM(TOP_CIKIS_MIK) FROM TBLSTOKPH

                  WHERE DEPO_KODU=115 AND STOK_KODU=HAM_KODU

                  ),0) AS DEPOBAKIYE_115,

    ---URETILEN

      ISNULL((SELECT SUM(URETSON_MIKTAR) FROM TBLSTOKURS WHERE URETSON_DEPO=145 AND URETSON_MAMUL = SUBSTRING(MAMUL_KODU,3,9)),0) AS URETILEN,

      ISNULL((SELECT SUM(URETSON_MIKTAR) FROM TBLSTOKURS WHERE URETSON_MAMUL = 'YT'+MAMUL_KODU),0) AS BOYAHANE_URETILEN,

      ISNULL((SELECT SUM(URETSON_MIKTAR) FROM TBLSTOKURS WHERE URETSON_MAMUL = HAM_KODU),0) AS DOKUMHANE_URETILEN,

    ---ISEMRI BAKIYELER

    ISNULL((SELECT SUM(BAKIYE) FROM zKORMETAL_ISEMRIBAKIYE_PSH WHERE STOK_KODU=SUBSTRING(MAMUL_KODU,3,9)),0) AS BOYAHANE_ISEMRI_BAKIYE,

    ISNULL((SELECT SUM(BAKIYE) FROM zKORMETAL_ISEMRIBAKIYE_PSH WHERE STOK_KODU=MAMUL_KODU),0) AS ISLEME_ISEMRI_BAKIYE,

    ISNULL((SELECT SUM(BAKIYE) FROM zKORMETAL_ISEMRIBAKIYE_PSH WHERE STOK_KODU=HAM_KODU),0) AS DOKUMHANE_ISEMRI_BAKIYE,

      --SATISLAR

      ISNULL((SELECT SUM(STHAR_GCMIK) FROM TBLSTHAR WHERE SUBE_KODU=10 AND STHAR_GCKOD='C' AND STHAR_FTIRSIP<>8 AND STOK_KODU = SUBSTRING(MAMUL_KODU,3,9)),0) AS TOPLAM_SATIS,

      ISNULL((SELECT SUM(STHAR_GCMIK) FROM TBLSTHAR WHERE SUBE_KODU=10 AND STHAR_GCKOD='C' AND STHAR_FTIRSIP<>8 AND C_YEDEK6 IS NULL AND STOK_KODU = SUBSTRING(MAMUL_KODU,3,9)),0) AS YURTICI_SATIS,

      ISNULL((SELECT SUM(STHAR_GCMIK) FROM TBLSTHAR WHERE SUBE_KODU=10 AND STHAR_GCKOD='C' AND STHAR_FTIRSIP<>8 AND C_YEDEK6='I' AND STOK_KODU = SUBSTRING(MAMUL_KODU,3,9)),0) AS YURTDISI_SATIS,

      ---ACIK SIPARISLER

      ISNULL((SELECT SUM(STHAR_GCMIK) FROM TBLSIPATRA WHERE SUBE_KODU=10 AND STHAR_HTUR='H'

            AND STOK_KODU = SUBSTRING(MAMUL_KODU,3,9)),0) AS ACIK_SIP_BAKIYE,

      --HURDA BILGILERI

      ISNULL

      ((SELECT SUM(STHAR_GCMIK)

      FROM TBLSTHAR WHERE STOK_KODU=(MAMUL_KODU) AND STHAR_ACIKLAMA LIKE 'H-JANT%'),0) AS BOYAISLEME_HURDA_BAKIYESI,

      ISNULL

      ((SELECT SUM(STHAR_GCMIK)

      FROM TBLSTHAR WHERE STOK_KODU='Y'+SUBSTRING(MAMUL_KODU,3,9) AND STHAR_ACIKLAMA LIKE 'H-JANT%'),0) AS DOKUM_HURDA_BAKIYESI,

      (ISNULL

      ((SELECT SUM(STHAR_GCMIK)

      FROM TBLSTHAR WHERE STOK_KODU=(MAMUL_KODU) AND STHAR_ACIKLAMA LIKE 'H-JANT%'),0)

      +

      ISNULL

      ((SELECT SUM(STHAR_GCMIK)

      FROM TBLSTHAR WHERE STOK_KODU='Y'+SUBSTRING(MAMUL_KODU,3,9) AND STHAR_ACIKLAMA LIKE 'H-JANT%'),0)) AS TOPLAMHURDA_BAKIYESI

FROM TBLSTOKURM,TBLSTSABIT

WHERE TBLSTOKURM.MAMUL_KODU=TBLSTSABIT.STOK_KODU

AND (SUBSTRING(MAMUL_KODU,3,9) LIKE '61%' OR SUBSTRING(MAMUL_KODU,3,9) LIKE '62%' OR SUBSTRING(MAMUL_KODU,3,9) LIKE '63%')

AND  HAM_KODU LIKE 'Y6%'

AND TBLSTSABIT.KOD_5='VERS1'

AND (SUBSTRING(MAMUL_KODU,3,9) IN (SELECT STOK_KODU FROM TBLSTSABIT WHERE KOD_5='VERS1'))

      ISNULL((SELECT SUM(STHAR_GCMIK) FROM TBLSTHAR WHERE SUBE_KODU=10 AND STHAR_GCKOD='C' AND STHAR_FTIRSIP<>8 AND STOK_KODU = SUBSTRING(MAMUL_KODU,3,9)),0) AS TOPLAM_SATIS,

      ISNULL((SELECT SUM(STHAR_GCMIK) FROM TBLSTHAR WHERE SUBE_KODU=10 AND STHAR_GCKOD='C' AND STHAR_FTIRSIP<>8 AND C_YEDEK6 IS NULL AND STOK_KODU = SUBSTRING(MAMUL_KODU,3,9)),0) AS YURTICI_SATIS,

      ISNULL((SELECT SUM(STHAR_GCMIK) FROM TBLSTHAR WHERE SUBE_KODU=10 AND STHAR_GCKOD='C' AND STHAR_FTIRSIP<>8 AND C_YEDEK6='I' AND STOK_KODU = SUBSTRING(MAMUL_KODU,3,9)),0) AS YURTDISI_SATIS,