Sadece kod1 i x olan carileri göstermek

SET ANSI_NULLS OFF

SET QUOTED_IDENTIFIER OFF

ALTER VIEW [dbo].[CASABIT] AS

SELECT TBLCASABIT.* FROM TBLCASABIT WITH(NOLOCK),NETCONTEXT,SRK_KUL

WHERE (((V$HOLDINGMI=1) OR (TBLCASABIT.ISLETME_KODU IN (-1,V$ISLETME_KODU))) AND

((V$MERKEZMI=1) OR (TBLCASABIT.SUBE_KODU IN (-1,V$SUBE_KODU)))) AND SRK_KUL.KULLANICI_NO=V$NETUSERID AND SRK_KUL.CARIKOD=TBLCASABIT.CARI_KOD AND

CARI_KOD NOT IN (

SELECT KOD FROM TBLKODHARICHAR DENYL

DENYL.TABLENAME = 'TBLCASABIT' AND

DENYL.SUBE_KODU = V$SUBE_KODU) AND

(

(V$WORKPLACEVARMI='' OR V$WORKPLACEVARMI IS NULL OR V$WORKPLACEVARMI='H') OR

(ONAYTIPI='' OR ONAYTIPI IS NULL OR ONAYTIPI='A') OR

(

(ONAYNUM IN (SELECT ONAYNUMARASI FROM TBLWORKFLOWTRA WHERE

SUBE_KODU = V$SUBE_KODU AND

KULLANICINO = V$NETUSERID AND

DURUMU = 'B' AND

TBLWORKFLOWTRA.ONAYNUMARASI = ONAYNUM)) AND

@@LOCK_TIMEOUT=1000000 AND

ONAYTIPI<>'' AND ONAYTIPI IS NOT NULL AND (ONAYTIPI='I' OR ONAYTIPI='U')

) OR

(@@LOCK_TIMEOUT<>1000000 AND ONAYTIPI<>'' AND ONAYTIPI IS NOT NULL AND ONAYTIPI = 'U')

)