#DateForumTypeThreadPost
1914 Jan 2015 @ 12:05 PSTDatabaseTopicRecursive updatesHi, I have a table with parent and child hierarchy. I need to frame an query to update an attribute in this table with respect to the value of its parent. Parent Child Status  A   &nbs...
1823 Oct 2014 @ 11:58 PDTDatabaseReplyhistory handled output requiredPlease get me sample query for this case.
1723 Oct 2014 @ 05:42 PDTDatabaseReplyhistory handled output requiredThere is no basic rule in the country or currency mapped to cust_id. Table A and Table B are two standalone tables , which has the cust_id as common key. We have to create  a view which will s...
1622 Oct 2014 @ 11:53 PDTDatabaseReplyhistory handled output requiredCan u plz get  me one sample  query  for this one. It  would  be helpfull here 
1522 Oct 2014 @ 01:35 PDTDatabaseReplyhistory handled output requiredHi Dieter, We need achieve a resut set in such a way all possible values for each Cust_id must be retrived with start date and end date.  
1422 Oct 2014 @ 12:07 PDTDatabaseReplyhistory handled output requiredYes we can also have duplicates ón cust_id, Table A and B  will have cust attributes for each customer with  different intervals also and here cust_id is the key which can be utilz...
1321 Oct 2014 @ 11:24 PDTDatabaseReplyhistory handled output requiredCan anyone plz help on this
1221 Oct 2014 @ 07:28 PDTDatabaseTopichistory handled output requiredHi , We have two tables with below data in given date intervals  and the output required is as single report  with its individual valid date intervals. Can anyone help on the query after...
1124 Jul 2014 @ 07:52 PDTDatabaseReplyNeed help on a case scenarioYes the query will run on daily basis. Can't predict the table size at this point. Yeah , we can include a  (valid_from, valid_to) range , but it will be set for key (ID,COUNTRY) of ...
1024 Jul 2014 @ 01:14 PDTDatabaseReplyNeed help on a case scenarioFrom Table2(Base Table) we have two dates , so for date "2014-07-20" the latest effective price(Table1) is from date "2014-07-12" and here we have only one price available which...
923 Jul 2014 @ 11:05 PDTDatabaseReplyNeed help on a case scenarioYeah , joining table1 and table2 , in which  ID , Country and date is the key and also the price must be picked in such a way like latest date price  is considered from the date in T...
823 Jul 2014 @ 11:25 PDTDatabaseTopicNeed help on a case scenarioHi All, I need a help on a Scenario to frame an sql. We have a price table which will have ID and Country level price or Country level price. Price must be picked from Table2 with respect to Date ...
715 Dec 2013 @ 08:48 PSTDatabaseReplyhelp required for a update scenarioTo more clarify, consider if we have two customer groups , one set with C1,C2 & C3 (C1 as primary) and second set with C4 & C5 (C4 as primary). The update to the daily data should work sepa...
615 Dec 2013 @ 06:36 PSTDatabaseReplyhelp required for a update scenarioYes Kiani
514 Dec 2013 @ 08:21 PSTDatabaseReplyhelp required for a update scenarioThanks Kiani, But here I have multile customer groups to be checked before updating the daily data. Like in above example we have one customer group with C1,C2 and C3 in which C1 is the customer w...
413 Dec 2013 @ 07:59 PSTDatabaseReplyhelp required for a update scenarioCan anyone please help on above query ?
313 Dec 2013 @ 05:07 PSTDatabaseReplyhelp required for a update scenarioI created a temp table to maintain the customer group information with a flag: temp_table  cust_id flag C1        Y C2        N C3     &n...
213 Dec 2013 @ 03:12 PSTDatabaseTopichelp required for a update scenarioHi, We have a customer group with some customer under it with different product. Need to update a value for below scenario. C1,C2 and C3 are from same customer group. Always qty<>cal_qty fo...
120 Nov 2013 @ 11:29 PSTDatabaseTopicneed help in implementing a scenario Here I have a scenario which needs to update a opening inventory with previous available closing inventory. For example please find table data as below. Now daily i have to run an update on ...