#DateForumTypeThreadPost
722 Jun 2016 @ 10:18 PDTDatabaseTopichow to create variable table nameHi there,             I have a query that requires reading data from one table on weekly basis, however, when it is end of month, all queries...
612 May 2016 @ 07:34 PDTDatabaseReplyperform plus or minus calcultions on multiple records based on their transaction codeHi atardecerR0j0... i have tried your code, it works perfectly.. thanx!!.. now it is abit more complicated... as attached graph.. when there is code 101 exist, I will grab transaction amount in 10...
512 May 2016 @ 01:08 PDTDatabaseReplyperform plus or minus calcultions on multiple records based on their transaction codethanx atardecerR0j0... it is quite late in australia, i will give it a try tomorrow.. thanx again!
411 May 2016 @ 11:33 PDTDatabaseTopicperform plus or minus calcultions on multiple records based on their transaction codeHi there,           I need some help on combining multiple transaction records in a table with same case id into one case. that is transaction code 101...
305 Apr 2016 @ 04:56 PDTTeradata DebuggerReplytable is not specified in the FROM clause or already aliased by another name error msg when using a variable from VTthanx Dieter.. seems working, even though, it seems taking extra running time to cross join two tables. but works.. :)
204 Apr 2016 @ 07:14 PDTDatabaseReplySQL for Deleting Data Older than n Years + current Year('01/01' || '/' ||TRIM((YEAR(CURRENT_DATE)-2) ))AS Dt_1
104 Apr 2016 @ 06:43 PDTTeradata DebuggerTopictable is not specified in the FROM clause or already aliased by another name error msg when using a variable from VTHi there,            I was developing VBA codes b4 being dragged in to do TeraData now (well, unfortunately no training provided). I have followin...