817 | 28 Apr 2006 @ 03:59 PDT | sheridany | Database | Topic | extract text string from text field in column | I have a table with email addresses and I need to extract out the name before the @ in the address. Data looks likes this in the column.joenoname@noname.com?jillnoname@noname.combob.k.noname@nonam... |
816 | 28 Apr 2006 @ 12:55 PDT | TDUser-781 | UDA | Reply | confidence showned in explain plan | Great!I've always supposed that index join confidence was not so good, due to my direct experience; but this was probably due to having poor statistics...Thank you for you explanation, have a nice ... |
815 | 28 Apr 2006 @ 11:21 PDT | dixon | UDA | Reply | confidence showned in explain plan | Hi TDUseri researched that an index join confidence occurs(in an EXPLAIN PLAN) when the join happenning between primary index column of one table with the primary or secondary index column of the o... |
814 | 28 Apr 2006 @ 09:40 PDT | Nytewynd | Database | Reply | Calculate hours | (date_1 - date_2) * 24 |
813 | 28 Apr 2006 @ 09:34 PDT | Nytewynd | Database | Reply | Populating column with constant day-of-week value? | select calendar_datefrom sys_calendar.calendarwhere day_of_week = 6 and calendar_date between date -6 and date |
812 | 28 Apr 2006 @ 09:21 PDT | Nytewynd | Tools | Reply | Pivot a table with SQL | The only way to do what you are asking about is with dynamic SQL. If you wanted a pivot showing sales by department by year, you might not know how many departments or years there are. You would ... |
811 | 28 Apr 2006 @ 09:15 PDT | Nytewynd | Tools | Topic | BTEQ | I am an Oracle developer that recently starting using Teradata. I would like to use BTEQ but the only tool I have installed is Queryman (an old version at that).What product do I need to install t... |
810 | 27 Apr 2006 @ 05:14 PDT | Mike | Database | Topic | Populating column with constant day-of-week value? | Hello,Here's something I've been wrestling with: I need a column of data that will indicate that the data was refreshed on a particular day of the week. Most likely it was be the past Friday's da... |
809 | 27 Apr 2006 @ 03:17 PDT | terauser1 | Database | Topic | Calculate hours | Need to find the number of hours between two dates to use in a where condition. Any quick solution/syntax? |
808 | 27 Apr 2006 @ 02:48 PDT | dcasady | Database | Reply | Negative spool while monitoring Session | Jim,I am seeing negative spoolspace numbers as well. I am using Teradata Manager 7.0 with V2R5.1.2. |
807 | 27 Apr 2006 @ 12:06 PDT | Fred | Database | Reply | TD olap func need help | You specified an ORDER BY for purposes of calculating the windowed OLAP function, but if you want the result set ordered you need an ORDER BY clause at the end.It's "Remaining" sum because you said... |
806 | 27 Apr 2006 @ 10:20 PDT | c9jad | Tools | Reply | Pivot a table with SQL | It seems if I need to know the number of columns that I will need in these solutions. I would potentially need 100 columns convert from rows. Do you have any other thoughts? |
805 | 27 Apr 2006 @ 09:13 PDT | MNagat | Database | Reply | Insert-Select | You are correct! Thanks very much.Shouldn't TD return an error message like "Insert failed due to dup row on set table"? |
804 | 27 Apr 2006 @ 05:50 PDT | floppy | Tools | Topic | How to display all columns with betq command | Hi,i know the bteq command: .set width n (n=20~254) but if there a table has many columns and exceed the 254 character limit, how can i output all columns to the screen.any help is appreciated.thanks. |
803 | 27 Apr 2006 @ 01:55 PDT | ragugct | Database | Topic | Relationship between Node and Database size | Hi,Is there a any relationship between number of nodes and size of the database...In case i need to load 20TB of data into staging and 2Tb of data into edw . what would be the minimum requirement o... |
802 | 26 Apr 2006 @ 10:04 PDT | BBR2 | Database | Reply | Insert-Select | If you are inserting into a set table all duplicates will be discarded.I assume this is what might have happened.Vinay |
801 | 26 Apr 2006 @ 05:20 PDT | rlaskar | UDA | Topic | SQL syntax to check values in a group | Hi All,I am trying to verify a table group by say ss_id, and say it returns 10 rows (same ss_id). Now I am trying to verify whether 10th row value > 9th row, 9th row > 8th row ...I need some feedba... |
800 | 26 Apr 2006 @ 05:11 PDT | MNagat | Database | Reply | Insert-Select | Hi all,I have witnessed a strange behaviour today after running an insert-select. Even though the select statement returns aproximately 50K rows, none was inserted and SQL Assistant completed it wi... |
799 | 25 Apr 2006 @ 04:30 PDT | cgard | Analytics | Topic | collaboration manager | Does anyone have any knowledge regarding Teradata's Collaboration Manager application. It appears to be a Web based application that is integrated with CRM Version 5.x and allows you to customize... |
798 | 25 Apr 2006 @ 09:18 PDT | young | Database | Topic | question about TD data distribution | as we all know TD store data based on row hash value, data from the same table will be stored together and within the same table data sorted by row hash or different table data rows will merge by t... |
797 | 24 Apr 2006 @ 02:52 PDT | samit_9999 | Database | Topic | Substr causing problem-killing query performance | Hi,I need to use Substr as part of my join condition.However its killing the performance of the query significantly.Is there any way i can improve performance of the query?SELECT s.col1FROM ABC s... |
796 | 22 Apr 2006 @ 10:38 PDT | BBR2 | Database | Reply | Collect Stats Report | Sathish,Thanks for sharing the information.I also wanted the stats date.I actually used the base View definition of MultiColumnStats to come up with this SQL. I can capture the last refresh time h... |
795 | 22 Apr 2006 @ 08:55 PDT | Sathish | Database | Reply | Collect Stats Report | Try :select * from dbc.multicolumnstats where tablename='XX' and databasename='XX'Thanks. |
794 | 22 Apr 2006 @ 03:54 PDT | Biju | Jobs | Topic | Teradata developer | We are looking for a Teradata Developer to be based in Bangalore, India.Pls reply with Cv in word format to bijujohn@synovaindia.comResponsibilities :• Datawarehouse ETL development using Teradat... |
793 | 21 Apr 2006 @ 01:24 PDT | BrianOtt | Jobs | Reply | Teradata Systems Engineer - Minneapolis/St Paul area | Bump |