Hi all,
I have a table that models a hierarchy of organizations (using the standard id/parent_id construction.) Add a small curve - there can be different versions of each hierarchy model (so w...
http://www.experts-exchange.com/Database/Oracle/Q_20073579.html
Zones:
OracleDate Answered: 02/07/2001 Grade: A Views: 0
folks
i have this query
SELECT a.parent ,a.location,c.wonum, b.wonum, c.description c.worktype,
FROM assignment b inner join workorder c ON ((b.wonum= c.wonum ))
RIGHT OUTER JOIN
...
http://www.experts-exchange.com/Database/Oracle/Q_22082966.html
Zones:
OracleDate Answered: 12/10/2006 Grade: A Views: 0
Is there an easy way to calculate what day of the week a specific date was PRIOR to Jan 1, 1970?
http://www.experts-exchange.com/Programming/Languages/CPP/Q_11578118.html
Zones:
C++Date Answered: 10/17/2000 Grade: A Views: 0
I'm looking for a alternate way of writing the query. I do not want to use the connect by clause. doesnt matter if it takes multiple steps.
select distinct group_code
from tab_hierarchy
star...
http://www.experts-exchange.com/Database/Oracle/Q_20221546.html
Zones:
OracleDate Answered: 06/13/2002 Grade: A Views: 0
Does UDB support the "CONNECT BY PRIOR" syntax for hierarchy select?
http://www.experts-exchange.com/Database/DB2/Q_20545386.html
Zones:
DB2Date Answered: 11/06/2004 Grade: A Views: 53
I have a table of Date Ranges as follows:
MthFrom MthTo
0 6
6 12
12 24
24 36
36 10000
I am tr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21409287.html
Hi
I have a senario were I need to display different levels of manager.
table Employees contains empid, mgrid, empname...
report looks similar below
level1(mgr3) level2(mgr2) level...
http://www.experts-exchange.com/Database/Oracle/Q_22058615.html
Zones:
OracleDate Answered: 11/13/2006 Grade: A Views: 0
folks
i have
SELECT LOCATION,PARENT, LPAD( ' ', LEVEL*2 ) || parent || ' ' || location
FROM LOCHIERARCHY
CONNECT BY parent = PRIOR LOCATION
START WITH parent IS NULL
in my lpad i want ...
http://www.experts-exchange.com/Database/Oracle/Q_22083240.html
Zones:
OracleDate Answered: 12/05/2006 Grade: A Views: 0
folks i have a query here
SELECT lochierarchy.parent,lochierarchy.location, remus.*
FROM lochierarchy left outer join (
SELECT workorder.location,
FROM remus.assignment, remus.workorder
WHE...
http://www.experts-exchange.com/Database/Oracle/Q_22096923.html
Zones:
OracleDate Answered: 12/20/2006 Grade: A Views: 4
I need to be able to retain the value of a field.
Example:
QTY 5
updated to QTY 7
I want to be able to sub QTY 5 from QTY 7.
Is this possiable & what do I need to do.
I am entering t...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22141289.html
Zones:
MS AccessDate Answered: 02/02/2007 Grade: A Views: 0
