REPEATED DATA IN ROWS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

REPEATED DATA IN ROWS

Author

Topic

alperozgur
Starting Member

16 Posts

Posted - 2004-10-11 : 04:09:53

Hi;
I've a query like :

DECLARE @Today_date int,@Musteri_Turu char(5), @Odeme_tipi char(2)
set @Today_date=(SELECT REPLACE(CONVERT(char(12), GETDATE(), 112),'/',''))
set @Musteri_Turu='MB'

SELECT A.ADD_CODE AS CARI, DUE_DATE,datediff(day,(select dbo.[IntToDateTime](DUE_DATE)),(select dbo.[IntToDateTime](@Today_date))) AS GUN_FARKI,
ISNULL(AMOUNT,0) AS TUTAR, ANAL_T0 AS WHO
INTO #TEMP
FROM SALFLDGBPT L (NOLOCK) INNER JOIN SSRFACC A (NOLOCK) ON A.ACCNT_CODE=L.ACCNT_CODE AND SUN_DB='BPT'
WHERE L.ACCNT_CODE LIKE '120%' AND SUBSTRING(A.ADD_CODE,1,2) IN (@Musteri_Turu) AND ALLOCATION IN ('5','') AND DUE_DATE>0 --AND JRNAL_TYPE='CKIAD'
AND datediff(day,(select dbo.[IntToDateTime](DUE_DATE)),(select dbo.[IntToDateTime](@Today_date)))<0 and AMOUNT<0

ORDER BY A.ADD_CODE

SELECT A.ADD_CODE AS CARI, DUE_DATE,datediff(day,(select dbo.[IntToDateTime](DUE_DATE)),(select dbo.[IntToDateTime](@Today_date))) AS GUN_FARKI,
ISNULL(AMOUNT,0) AS TUTAR, ANAL_T0 AS WHO--, PAYMNT_DAY AS ODEME_GUNU,A.ANAL_A4 AS VADE_KATEGORI
INTO #TEMP1
FROM SALFLDGBPT L (NOLOCK) INNER JOIN SSRFACC A (NOLOCK) ON A.ACCNT_CODE=L.ACCNT_CODE AND SUN_DB='BPT'
WHERE L.ACCNT_CODE LIKE '120%' AND SUBSTRING(A.ADD_CODE,1,2) IN (@Musteri_Turu) AND ALLOCATION IN ('5','') AND DUE_DATE>0 --AND JRNAL_TYPE='CKIAD'
AND datediff(day,(select dbo.[IntToDateTime](DUE_DATE)),(select dbo.[IntToDateTime](@Today_date)))>0 and AMOUNT<0

ORDER BY A.ADD_CODE

SELECT #TEMP.CARI,B.ACCNT_NAME AS BAYI,#TEMP.WHO,C.NAME,ISNULL(#TEMP.GUN_FARKI,0) ,ISNULL(#TEMP.TUTAR,0) AS GECIKEN, ISNULL(A.TUTAR,0) AS ILERI_VADE, (#TEMP.GUN_FARKI * #TEMP.TUTAR) AS GEC1,B.CREDIT_LIM AS KREDI FROM #TEMP
INNER JOIN #TEMP1 A ON A.CARI=#TEMP.CARI
INNER JOIN SSRFACC B ON B.ADD_CODE=#TEMP.CARI AND B.SUN_DB='BPT'
INNER JOIN SSRFANV C ON C.CODE=#TEMP.WHO AND C.CATEGORY='T0' AND C.SUN_DB='BPT'
ORDER BY #TEMP.CARI
when i run this query the result is like :
MB0007 TANJU TURAMANLAR 46221 Izmir/Aliaga Saha Müdürü -814 -1180957.000 -102661.000 961298998.000 24514286
MB0007 TANJU TURAMANLAR 46221 Izmir/Aliaga Saha Müdürü -814 -607000.000 -102661.000 494098000.000 24514286
MB0007 TANJU TURAMANLAR 46221 Izmir/Aliaga Saha Müdürü -29 -38940.000 -102661.000 1129260.000 24514286
but in the result the -102661,000 only belongs to the second record. how can i stop it's repeating when the field is null

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources