#DateForumTypeThreadPost
6508 Feb 2012 @ 06:24 PSTDatabaseTopicEnd of line in a string Hi    i have column in my table with formatted string data  like wise    'TYPE de Question:      Plainte: Facturation' ...
6402 Feb 2012 @ 07:08 PSTDatabaseReplyoptimizing the Select Query IF I WANT THE SECOND  MAXIMUM CDR_SEQUENCE_NR , THEN HOW TO CONVERT THIS WITHOUT ANY SUB DATASETS.
6301 Feb 2012 @ 11:10 PSTDatabaseReplyoptimizing the Select Query Need every combination of PGW_IP_ADDRESS,PDN_CONNECTION_ID  columns count and maximum CDR_SEQUENCE_NR .     
6201 Feb 2012 @ 05:09 PSTDatabaseTopicoptimizing the Select Query Hi   i would like to re - write the below mentioned query to a single query without any datasets to create. as it is taking so much of time to execute, any suggestion to adapt t...
6130 Jan 2012 @ 05:18 PSTDatabaseReplyUnable to create a Before Trigger any suggestions please
6030 Jan 2012 @ 05:04 PSTDatabaseReplyUnable to create a Before Trigger Any one please suggest me little bit urgent.
5930 Jan 2012 @ 04:33 PSTDatabaseReplyUnable to create a Before Trigger Agree with you, but  customers will updates the name through a web interface. the web interface will behave in such away that if we define the INDEX or Constraint those columns are not edit...
5830 Jan 2012 @ 04:03 PSTDatabaseReplyUnable to create a Before Trigger any one would please suggest me, its a little bit urgent
5730 Jan 2012 @ 01:56 PSTDatabaseReplyUnable to create a Before Trigger BEFORE TO UPDATE  I WOULD LIKE TO CHECK WHETHER THE SAME NAMES ARE ALREADY EXISTING IN THE TABLE, IF EXISTING ABORT THE  ACTION. for this i had created a table and  trying to ...
5629 Jan 2012 @ 02:00 PSTDatabaseReplyUnable to create a Before Trigger any suggestions
5527 Jan 2012 @ 01:28 PSTDatabaseReplyUnable to create a Before Trigger any one please suggest me
5427 Jan 2012 @ 12:32 PSTDatabaseTopicUnable to create a Before Trigger Hi   im trying to create a view on a table : CREATE TABLE sample_test ( id INTEGER ,name VARCHAR(200) )NO PRIMARY INDEX   REPLACE TRIGGER SAMPLE_T...
5305 Jan 2012 @ 10:41 PSTDatabaseTopicSuggestion about collect stats Hi   I have 20 tables for my application in DWH, i'm planning to  do  collect stats on all the columns of these 20 tables.   All these tables are used for...
5209 Dec 2011 @ 10:09 PSTDatabaseReplyJoining tables issue yes this is a pivot query by using stored procedure. i want a resultant dataset like this cust_id  prod_id prod_name  prod_a_amnt   prod_b_amnt  ...................
5109 Dec 2011 @ 07:46 PSTDatabaseReplyJoining tables issue the query will be like this from my stored procedure   @dnoeth   :  Sel prd.cust, prd.product_name, sum(prd1.product_amt)  product_a_amnt ,s...
5009 Dec 2011 @ 07:17 PSTDatabaseReplyJoining tables issue @dnoeth   :  Thanks for your reply. here  i have different products and i dont know in advance  how many products. So we are using procedure to build the sql...
4909 Dec 2011 @ 06:22 PSTDatabaseReplyJoining tables issue I have a table  with data records count  68710147  and  i'm using the same table  in the joing part to get the counts and the sum's   ...
4809 Dec 2011 @ 04:50 PSTDatabaseTopicJoining tables issue I have a table  with data  68710147 and  i'm using the same table  in the joing part to get the counts and the sum's   like :   Sel prd....
4722 Nov 2011 @ 11:11 PSTDatabaseReplyunable to create a table with 600 columns Any suggestions from any one
4621 Nov 2011 @ 03:03 PSTDatabaseReplyunable to create a table with 600 columns any one please give me a suggestion on the same
4521 Nov 2011 @ 02:37 PSTDatabaseReplyunable to create a table with 600 columns Hi   we tried to create a table with 600 columns , now the table is created .    after inserting the data into the table and selecting the data from that table we ...
4415 Nov 2011 @ 08:38 PSTDatabaseTopicunable to create a table with 600 columns Hi   we are trying to create a table in Teradata 13.10 version with 600 columns for reproting purpose .   But we are unable to create the table ,the same type of table ...
4309 Nov 2011 @ 08:06 PSTDatabaseReplyHigh Skewness @Woddy : Would you please comment
4209 Nov 2011 @ 07:28 PSTDatabaseReplyHigh Skewness Those are the tables and the query .
4109 Nov 2011 @ 07:12 PSTDatabaseReplyHigh Skewness changing the query   INSERT INTO sample_tbl SEL * FROM product_region_1 WHERE (prod_code,ord_date,contact) NOT IN (SELECT prod_code,ord_date,contact FROM product_reg...

Pages