#DateForumTypeThreadPost
1401 Nov 2015 @ 04:07 PSTDatabaseTopicSumming a count (*) colum Hi there, I have been trying to sum the MY_ID_COUNT (i.e. MY_ID, count (*)) column but without success. Would be cool to have the total displayed. Curent resultset looks like this: --------...
1321 Oct 2015 @ 08:11 PDTDatabaseReplyLeast/Greatest Function with DatesThank God i lived to see master Dieter say dont 'ask me why' :) In life nothing is impossible!
1217 Sep 2015 @ 06:19 PDTDatabaseReplySUBSTRING and CONCATENATIONThank you Saravanath. much appreciated.
1116 Sep 2015 @ 04:25 PDTDatabaseReplySUBSTRING and CONCATENATION Hi Mani et al, What I want to do now is to do a count over my resultset. The distinct function below is working (but I want something to tell me the number of occurrence of the duplicates):...
1016 Sep 2015 @ 04:18 PDTDatabaseReplySUBSTRING and CONCATENATIONHi Mani. thanks for your help - works perfectly.
914 Sep 2015 @ 09:12 PDTDatabaseTopicSUBSTRING and CONCATENATION Hi There, i need help to write an sql script to return values from different positions within the example string below: #12345678.#98B9876.#123456 i want values from positions 2-8 and conc...
826 Nov 2014 @ 08:49 PSTDatabaseReplycopy/backup table Hi Ulrich -  Yes its on the same server. Thank you for your help. Alls good with your help.
725 Nov 2014 @ 07:35 PSTDatabaseTopiccopy/backup table I want to copy/backup an entire table with a different name so i can make some updates and test those changes on my version of the table. Can you please provide help on how to do this? Best Regar...
621 Oct 2014 @ 07:42 PDTDatabaseReplyDIFF BETWEEN PRIMARY KEY AND PRIMARY INDEXthanx @KS42982 for your post on the diff between primary key and primary index
502 Oct 2014 @ 09:09 PDTDatabaseReply How to sum up totals from different columns and insert into one columnthanks Raja K Thaw. works well.
402 Oct 2014 @ 04:19 PDTDatabaseTopic How to sum up totals from different columns and insert into one column How to rsum up totals from different columns and insert into one column Hi there, I have created a column to hold the total amounts for all amounts types recorded against an event. the i...
302 Oct 2014 @ 04:03 PDTDatabaseReplyTeradata Error: [3704] '' ('0A'X) is not a valid Teradata SQL token. How to rollup totals from different columns and insert into one column Hi there, I have created a column to hold the total amounts for all amounts types recorded against an event. the...
201 Oct 2014 @ 05:37 PDTDatabaseReplyTeradata Error: [3704] '' ('0A'X) is not a valid Teradata SQL token.thanks Dieter. sorry i was away on leave just got back this morning! yes it was a back tick. alls good now. Unfortunately teradata sql is my first and its getting me excited! my current task is...
125 Sep 2014 @ 10:05 PDTDatabaseReplyTeradata Error: [3704] '' ('0A'X) is not a valid Teradata SQL token.hi there. am learning teradata sql (sql ingeneral) and i got this error: SELECT Failed. [3704] '' ('60'X) is not a valid Teradata SQL token. the script was running well until i d...