#DateForumTypeThreadPost
1401 Feb 2010 @ 06:05 PSTDatabaseTopicROW TO COLUMN CONVERSIONFolks I have a staging table which gives data as shown below.Month Hotel_id Loss_IncuredMar 63 200Apr 63 300Jun 63 400I got the missing month from the ...
1301 Feb 2010 @ 06:03 PSTDatabaseTopicROW TO COLUMN CONVERSIONFolks I have a staging table which gives data as shown below.Month Hotel_id Loss_IncuredMar 63 200Apr 63 300Jun 63 400I got the missing month from the ...
1219 Jan 2010 @ 06:56 PSTDatabaseTopicfast load errorHi folks,I am trying to use a FLD script to load a single file into teradata.But I get the error Not enough fields in vartext data record number:11what does this error mean?I have set record vartex...
1107 Jan 2010 @ 03:20 PSTDatabaseTopicAll rows issueHi folks, need some help on this.To get all the days for all the hotel_id i am doing the following query.selecthotel_id,hotel_date,week_idmth_id,from hotel_prod, calendar_prodThis gives me hotel_id...
1005 Jan 2010 @ 10:29 PSTDatabaseTopicCSUM ISSUEPlease look at the two querys below.When I add a filter in the first select i get the correct results.I did this to check if i was getting correct results for a hotel_id.I am calculating the till d...
905 Jan 2010 @ 09:59 PSTDatabaseReplyOuter join Issuethanks a lot Sir, I was able to resolve the issue
829 Dec 2009 @ 01:23 PSTDatabaseReplyOuter join IssueOr can any one help me write a query that will bring back hotel_id for all the week_id and month_id. instead of null
729 Dec 2009 @ 12:42 PSTDatabaseReplyOuter join IssueCan any one help me with this...Is there a replace function in teradata with which i can replace it with the original hotel_id where reservation date is not null for that particular month_id for a...
629 Dec 2009 @ 08:43 PSTDatabaseReplyOuter join IssueNo I cannot,I have only listed one hotel for the example but there are numerous hotels in the table
528 Dec 2009 @ 11:02 PSTDatabaseTopicOuter join Issuehi folks, I am stuck with a typical right outer join issue.Here is my query. I am trying to insert data into a table.Insert Into table XYZ(SelectHotel_id,month_id,week_id,romm_reserve_dtfromhotel_t...
421 Dec 2009 @ 02:07 PSTDatabaseTopiccalculating for last weekHi folks, I am unable to resolve one issue. Please look at the query below.Selecthotel_id,hotel_week_id,sum(paidearly_rooms_rev) as reserved_rooms_rev,sum(paidlate_rooms_rev) as blocked_rooms_revfr...
321 Dec 2009 @ 12:53 PSTUDAReplyNeed help loading datathanks for the replies guys. I cannot do it on unix because we run entirely on windows.from your comments above does it mean the load file should look like this.Instead of FILE=\\IS02corp\rec\Files...
220 Dec 2009 @ 02:09 PSTUDATopicNeed help loading dataHi Experts,I am new to Tera data development...I am trying to insert multiple files that are in csv format into one tera data table...The code mentioned below works file for one file at a time but ...
120 Dec 2009 @ 02:07 PSTDatabaseTopicInsterting CSV File data into a tera data tableHi Experts,I am new to Tera data development...I am trying to insert multiple files that are in csv format into one tera data table...The code mentioned below works file for one file at a time but ...