|
|
Archives of the TeradataForum
Message Posted: Thu, 14 Dec 2006 @ 21:24:49 GMT
Subj: | | Re: Question regarding duplicated identity columns |
|
From: | | Dieter Noeth |
Anomy.Anom wrote:
| The above query returned 2 rows, with the source_id as we had specified in the query, but the Acct_Sid is exactly the same(-
999999999902734210). | |
No, it isn't, it just looks the same :-)
Let me guess: You're running that query using QueryMan, so it's just a display problem:
select -999999999902734210, -999999999902734211;
-999999999902734210. -999999999902734211.
-999.999.999.902.734.210 -999.999.999.902.734.210
Tools -> Options -> Answerset -> Displaying Full Accuracy for BigInt and Decimal (16) and Above
Dieter
| |