19 | 14 Jan 2015 @ 12:05 PST | Database | Topic | Recursive updates | Hi,
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... |
18 | 23 Oct 2014 @ 11:58 PDT | Database | Reply | history handled output required | Please get me sample query for this case.
|
17 | 23 Oct 2014 @ 05:42 PDT | Database | Reply | history handled output required | There 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... |
16 | 22 Oct 2014 @ 11:53 PDT | Database | Reply | history handled output required | Can u plz get me one sample query for this one. It would be helpfull here
|
15 | 22 Oct 2014 @ 01:35 PDT | Database | Reply | history handled output required | Hi 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.
|
14 | 22 Oct 2014 @ 12:07 PDT | Database | Reply | history handled output required | Yes 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... |
13 | 21 Oct 2014 @ 11:24 PDT | Database | Reply | history handled output required | Can anyone plz help on this |
12 | 21 Oct 2014 @ 07:28 PDT | Database | Topic | history handled output required | Hi ,
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... |
11 | 24 Jul 2014 @ 07:52 PDT | Database | Reply | Need help on a case scenario | Yes 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 ... |
10 | 24 Jul 2014 @ 01:14 PDT | Database | Reply | Need help on a case scenario | From 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... |
9 | 23 Jul 2014 @ 11:05 PDT | Database | Reply | Need help on a case scenario | Yeah , 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... |
8 | 23 Jul 2014 @ 11:25 PDT | Database | Topic | Need help on a case scenario | Hi 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 ... |
7 | 15 Dec 2013 @ 08:48 PST | Database | Reply | help required for a update scenario | To 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... |
6 | 15 Dec 2013 @ 06:36 PST | Database | Reply | help required for a update scenario | Yes Kiani |
5 | 14 Dec 2013 @ 08:21 PST | Database | Reply | help required for a update scenario | Thanks 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... |
4 | 13 Dec 2013 @ 07:59 PST | Database | Reply | help required for a update scenario | Can anyone please help on above query ?
|
3 | 13 Dec 2013 @ 05:07 PST | Database | Reply | help required for a update scenario | I created a temp table to maintain the customer group information with a flag:
temp_table
cust_id flag
C1 Y
C2 N
C3 &n... |
2 | 13 Dec 2013 @ 03:12 PST | Database | Topic | help required for a update scenario | Hi,
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... |
1 | 20 Nov 2013 @ 11:29 PST | Database | Topic | need 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 ... |