quote:

---

Originally posted by alperozgur

Hi;
i have a query as belows. My problem is i want my query checking the red colored conditions but not getting the records that agrees with the condition, only checking it. how can i do that?

Query:

DECLARE @Today_date int, @Musteri_Turu char(3), @Odeme_tipi char(2)
set @Today_date=(SELECT REPLACE(CONVERT(char(12), GETDATE(), 112),'/',''))
set @Musteri_Turu='MA%'
set @Odeme_tipi='HH'

SELECT A.ADD_CODE AS CARI_HESAP_KODU, PAYMNT_DAY AS ODEME_GUNU, DUE_DATE AS VADE, datediff(day,(select dbo.[IntToDateTime](DUE_DATE)),(select dbo.[IntToDateTime](@Today_date))) AS GUN_FARKI,
AMOUNT AS TUTAR, A.ANAL_A4 AS VADE_KATEGORI, ANAL_T0 AS WHO ,DESCRIPTN AS ACIKLAMA INTO #TEMP1
FROM SALFLDGBPT L (NOLOCK)
INNER JOIN SSRFACC A (NOLOCK) ON A.ACCNT_CODE=L.ACCNT_CODE AND A.SUN_DB='BPT'
JOIN SSRFADB ZZ (NOLOCK) ON L.ACCNT_CODE=ZZ.ACCNT_CODE WHERE L.ACCNT_CODE LIKE '120%' AND A.ADD_CODE LIKE @Musteri_Turu AND DUE_DATE>0 AND ALLOCATION IN (' ','5') AND DUE_DATE < @Today_date
AND ZZ.ANAL_C7<>'4' AND ZZ.SUN_DB='BPT'
SELECT * FROM #TEMP1 ORDER BY 1,3,4
DROP TABLE #TEMP1

---