#DateForumTypeThreadPost
1424 Nov 2014 @ 06:02 PSTDatabaseTopicIssues with Decimal Field in Fastload ScriptHi- I am using a fastload script to load a .csv into Teradata. The only problem I am having is with importing the data in the   "Charge" column as a decimal. Typically data in this c...
1303 Sep 2014 @ 08:41 PDTAnalyticsReplyusing "CONCAT" function in BTEQ causes 3706 Syntax error but works through SQL AssistantNevermind, figured it out on my own by using method described here: http://teradatasql.com/how-to-concatenate-in-teradata/   New working query looks like this:   Insert Into db.tabl...
1203 Sep 2014 @ 08:21 PDTAnalyticsTopicusing "CONCAT" function in BTEQ causes 3706 Syntax error but works through SQL AssistantHere is the query I am running: Insert Into db.table2 sel ,order_id , order_name , CONCAT('https://website.com/',order_id) order_hyperlink from db.table1;     When I ...
1126 Aug 2014 @ 02:17 PDTDatabaseReplyDetermine status on a given date Sorry I was extremely unclear. Please ignore my terrible attempt and hacking that query together.   I'll try to explain better:   I have a table (db.sta...
1025 Aug 2014 @ 05:50 PDTDatabaseReplyDetermine status on a given dateThanks Dieter -    I am interested in using the EXPAND method but am not sure exactly how to apply this as the prior example seems to be focused on dates, and I am trying to populate th...
912 Aug 2014 @ 10:25 PDTDatabaseReplyDetermine status on a given dateThank you cmedved! This makes a ton of sense. I also agree with your logic regarding the macro.   Moreover, my bigger goal is to create a table which has all dates up to today, the account_i...
811 Aug 2014 @ 02:41 PDTDatabaseReplyDetermine status on a given dateAnd this is how I would want to see the result to determine status on June 21, 2014: _date            account_id          account_status_on_d...
711 Aug 2014 @ 02:39 PDTDatabaseReplyDetermine status on a given dateThis is the format of the [db.stage_moves] table: _date             account_id        old_value        new_value 5/21/20...
611 Aug 2014 @ 02:32 PDTDatabaseTopicDetermine status on a given dateI have a table (status_moves) which logs each time a record changes status. It looks like this: [db.stage_moves] _date account_id old_v...
522 Jul 2014 @ 06:40 PDTDatabaseReplyUPDATE Statement using LEFT JOIN and CASE statementThanks Rglass! works with this corrected syntax of the "FROM" coming first.  
422 Jul 2014 @ 10:13 PDTDatabaseTopicUPDATE Statement using LEFT JOIN and CASE statement UPDATE db.source   SET   region= CASE WHEN b.title_rw LIKE '%East%'  THEN 'East' WHEN b.title_rw LIKE '%Central%'  THEN 'Centr...
302 Jul 2014 @ 03:02 PDTDatabaseReplyI Have totals by date, - want to get total "to date" for each dateWow thanks for the speedy response, Dieter! Was too busy working on updating to realize you had already provided an excellent solution.   Appreciate the help.
202 Jul 2014 @ 02:53 PDTDatabaseReplyI Have totals by date, - want to get total "to date" for each dateupdate- still can't get it quite right, but was able to get close after doing some digging/reading on OVER clauses for SUM to get running totals.   Also wanted to give more detail as to ...
102 Jul 2014 @ 01:49 PDTDatabaseTopicI Have totals by date, - want to get total "to date" for each dateHello -  I'm hoping someone can give a little guidance  on how to create a table that includes a "sum to date" - I believe there must be a simple way to do this but I have ...