#DateForumTypeThreadPost
826 Jun 2006 @ 04:19 PDTToolsReplySQL problemThanks Dieter,I apologise for overlookin Distinct clause. Actually I was not aware of using Distinct in Having clause. I never used my common sense that I should try using Distinct while counting...
726 Jun 2006 @ 03:46 PDTToolsReplySQL problemThanks Dieter for your response.If I use this SQL then it will return me with all the customers having data for 6 months only. But this is not my requirement. I need customers having CONSECUTIVE 6 ...
623 Jun 2006 @ 10:00 PDTToolsTopicSQL problemHi All,We have a requirement wherein we need to gather the list of customers having transaction accounts in the last consecutive 6 months.A customer can have more than one account & irrespective of...
504 May 2006 @ 06:55 PDTDatabaseReplyHow to find a lost password for a userThanks,But what if you forgets your only Administrators password :-) I know in a work situation it will not happen as you will have more than one administrators. This question come up when I was d...
404 May 2006 @ 05:01 PDTDatabaseTopicHow to find a lost password for a userHi,Can anyone let me know if there is any way we can retrieve the user's password from any system table in Teradata.If someone forgets his/her SYSDBS password then what is the way to retrieve that....
305 Apr 2006 @ 03:50 PDTToolsReplyNumeric overflowThanks Barry!I thought there should be a straight forward way of doing it, but after looking at your reply I also believe that it could only be done this way in Teradata.Amit
203 Apr 2006 @ 04:51 PDTToolsReplyNumeric overflowThanks for the reply. I know (18,2) will only have 16 digits to the left of the decimal. But my question is how can we treat a number having more than 16 digits to the left of the decimal. I hope I...
130 Mar 2006 @ 07:36 PSTToolsTopicNumeric overflowI am running this query SELECT 12345678901234567 (DECIMAL(18,2)) (FORMAT 'ZZ,ZZZ,ZZZ,ZZZ,ZZZ,ZZ9.99')Error comes:Code = 2616: Numeric overflow occurred during computation. If I try to increase the ...