question

vanapandi avatar image
vanapandi asked

sql query and result

i need storedprocedure for bind product with head product and child Ex: productId Name Desc Price --------- ----- ----- ------ 0 0 Furniture 0 1235 Wood 50x100 cm plywood need 1000 3421 Fevicol Fevicol 100gm 25 0 0 DOOR o 1674 Teak Wood Purchased from vendor. 10000 here Furniture and Wood is Head and also those have Head id that referred in Child Table. Ex: productid head_id salesId --------- ------ -------- 2321 3 2345 5453 3 2345 65445 45 2345 ![alt text][1] [1]: /storage/temp/642-product+and+head.png
sql-server-2008sql-server-2005stored-proceduresquery-results
product and head.png (31.9 KiB)
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
Forgive, me but I don't clearly understand what you are asking for. Can you post the DDL of all of the tables involved and maybe some sample data? Are you looking for hierarchy results? Also, you marked both SQL 2005 & @2008, which one is it?
0 Likes 0 ·
anthony.green avatar image anthony.green commented ·
OP posted here as well http://www.sqlservercentral.com/Forums/Topic1416946-391-1.aspx#bm1416987
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.