February 17, 2010 at 8:40 am
i have table which has hierarichal data that i need to display , i need sql query for that. here is the table description:-
Table name - test
Model_nbr - varchar(35)
Bom_Level - int
kit_item_nbr- varchar(35)
Desc - varchar(50)
Here kit_item_nbr is the child model nbr and BOM level is the level of that model under Model_nbr
February 17, 2010 at 9:06 am
I recommend that you read the first link in my signature, and then post readily-consumable table creation (DDL) and test data (DML) scripts, along with what the expected output from the test data would be.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy