Archives of the TeradataForum

Message Posted: Thu, 14 Dec 2006 @ 21:34:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, December 14, 2006 16:04 -->

Perhaps Acct_SID is not duplicated, this is just the ODBC limit of 15 decimal digits making the result rows appear the same?

     SELECT CAST(Acct_SID AS CHAR(19)), count(*) FROM acct GROUP BY Acct_SID
     HAVING count(*) > 1;

     Select CAST(ACCT_SID AS CHAR(19)), source_id_1 from Acct where
     source_id_1 IN ('1','2');

	<Prev	Next>		<<First	<Prev	Next>	Last>>