#DateForumTypeThreadPost
1109 Oct 2014 @ 04:02 PDTDatabaseReplymatch against next rowHi, If the condition product_no, Product_desc and product_code is the same on the next row and the job_no differ then the diff-column will calculate the differens in cost between (in this case row...
1009 Oct 2014 @ 12:50 PDTGeneralReplyCompare current row with previous row in TEradataHi Dieter, I've tried to add the partition by but it always gives me an error. How would it look like with a partition by?   Thanks, Emil
909 Oct 2014 @ 12:22 PDTDatabaseTopicmatch against next rowHi everyone, I'm trying to create a derived table that has a dimension that calculates either next row's value or the previous row's value (next or previous doesn't matter). ...
818 Sep 2014 @ 08:15 PDTDatabaseTopicA more efficient way to reload dataHi everyone,   Im facing a small problem, having a procedure that drops the whole table and refreshes (i'm not totally sure that this is the correct way to describe it) will cause some...
718 Sep 2014 @ 07:50 PDTDatabaseTopiccreating table with sum-functionHi everyone,   Im trying to create a table but when try to run it, it says:   EXPLAIN Failed.  [3707] Syntax error, expected something like a 'CHECK' keyword between ...
611 Sep 2014 @ 02:05 PDTDatabaseReplycopying table from Prod to QAThank you very much Raja!
511 Sep 2014 @ 01:19 PDTDatabaseReplycopying table from Prod to QAOk, I see. Thank you for your help.   Let us think that I want to fill table A with data from table B. How should I then write the SQL?   Best Regards, Emil
411 Sep 2014 @ 12:53 PDTDatabaseReplycopying table from Prod to QAActually I don't know what TPT or TPT Wizard is...   Mostly I just check my queries from BO Web Intelligence in Teradata and very seldom I do this kind of tasks. I'm wondering if t...
310 Sep 2014 @ 11:42 PDTDatabaseTopiccopying table from Prod to QAHi everyone, I'm struggling with a problem where I'm suppose to copy the data from table Technical_year in prod environment to Technical_year in QA environment. They are actually views an...
219 Aug 2014 @ 06:53 PDTConnectivityReplyStored ProcedureOk I see, but in order to make a SP i need to know the structure of an SP and that's where I lack in experience. I've tried to read manuals and guides but without success. I would be very g...
119 Aug 2014 @ 04:30 PDTConnectivityTopicStored ProcedureHi everyone,   I'm pretty green at this field but I have to create a table from a select statement i've made and it has to be done though a stored procedure.   I'm wonder...