recursive query

• schauhan13

  SSC Eights!

  Points: 901

  More actions

  February 17, 2010 at 8:40 am

  #219224

  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

• WayneS

  SSC Guru

  Points: 95461

  More actions

  February 17, 2010 at 9:06 am

  #1120175

  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

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2