Arjun,

Thanks for this. In the update statement @total is actually a summation of the quantity field, how can we capture that in one update statement ?

Find attached the files for...

Dear Hardik,

I have tried outputting @TOTAL and I only get one value, the last row. The update hence is made for that row only. Please find attached the two...

Instead of an IF statement , should I make use of a while loop ?

Thanks,

Am not sure which book you are suggesting : Is it understanding and using APPLY 1 ? Could you suggest where I could purchase it from ?

Yes, It gives everything. Thanks for that. But if the CPU was produced 20 times or there were 20 production runs for the CPU then It would display all the...

Ok,

Am sure you've heard of the recursive query or the BOM CTE.It works with hierachical data. It works this way :- You have a certain item say computer set, this...

I think a string of CTE's would be in the works though tedious, however the tricky part is how to keep sending over the production number and item code of...

The database is attached herein. Click here to download

http://www.sqlservercentral.com/Forums/Attachment4424.aspx

Dave,

Well, yes there could be a chain of CTEs but how many ? 12 CTEs ? This was just my way of...

MISTAKE IN POSTING. DELETE THIS DOUBLE POST PLEASE. REFER TO THE FIRST POSTING ABOVE.

Find the attached samples DB with the four tables used in the query. Kind run the...

I have attached a samples database with all the four tables used. Use the query below :-

The item P10004 is a parent item. It returns 3 rows of items, two...

This query will go through a maxrecursion 12, as indicated in the edited post. Sorry I left that out.

Ok, Please help me out construct this query, its a bit long but I need to know how to achieve the required result set. Please bear with and all explain...

Ok,

This is what I am trying to do :

Using a certain query I get the following results

ItemName ItemCode TreeType

Book ...

Thanks,

But how would I capture the out put in a variable because even this

set @parent = (select T0.AppObjType

from oinm T0

inner join ibt1 T1 on T0.ItemCode = T1.ItemCode

and...

Thanks, but how exactly ?