Connect by prior command

Expand Post »

Hi All,
Can anybody give me a solution how to solve or write a query for this scenario?

there is table called ITT1 with the columns

FATHER, CHILD_NUM, CODE, CODE_QTY
a 1 b 1
b 1 c 1.5
c 1 d 2
d 1 e 1

There are 3 columns father,child_num,code & the code_quantity.
It is explained as 'a' is my FINAL finished good and is produced from raw material 'b' using 1kg.
and here 'b' becomes my finished good and is produced from raw material 'c' using 1kg.
and here 'c' becomes my finished good and is produced from raw material 'd' using 1kg.
and here 'd' becomes my finished good and is produced from raw material 'e' using 1kg.

now i want how much raw material 'e' is required to produced for eg. 20kg of 'a'

should i use connect by prior or sub queries will help in this regards.
kindly advice.

Regards,
Faheem

Similar Threads

sql query problem with MS Access and C# in C#
$HTTP_POST_VARS['command'] in PHP
OS 10.4 2 Win2k server problem in Mac OS X
how to make a simple script? in C++
I am New In MySQL. Problem With MySQL Database Plz Help. in MySQL

sk.faheemuddin

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2009

Permalink

Nov 10th, 2009

Re: Connect by prior command

MS SQL Syntax (Toggle Plain Text)
SELECT code_qty *10 FROM ITT1 WHERE code=
(SELECT father FROM ITT1 WHERE code=
	(SELECT father FROM ITT1 WHERE code = 
		(SELECT father FROM ITT1 WHERE code = 'a')
	)
)
select code_qty *10 from ITT1 where code=
(select father from ITT1 where code=
	(select father from ITT1 where code = 
		(select father from ITT1 where code = 'a')
	)
)

network18

Reputation Points: 29

Solved Threads: 76

Practically a Master Poster

Offline

616 posts
since Sep 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Stored Procedures to insert into a table

Next Thread in MS SQL Forum Timeline: MS SQL Recursion problem

DaniWeb Message

Cancel Changes

User Name
Password