hierarchical linking of locations to each other

• hoseam

  SSCertifiable

  Points: 5533

  More actions

  November 1, 2013 at 7:44 am

  #299828

  I need help here, I have this table, I may need to create another column I'm not sure yet.

  CREATE TABLE [dbo].[Location](

  [LocationID] [int] IDENTITY(1,1) NOT NULL,

  [Location] [nvarchar](255) NOT NULL,

  [Product_Code] [nvarchar](255) NOT NULL,

  [LocationProductStockAmt] [decimal](18, 2) NULL)

  And I need to create a database object that can store hierarchical linking of locations to each other. Ensure referential integrity is enforced.

  One location cannot be linked to more than one parent location.

  For example if I have location South Africa and I want to link Gauteng and to Gauteng I want to link Johannesburg. South Africa => Gauteng => Johannesburg

• Ed Wagner

  SSC Guru

  Points: 287024

  More actions

  November 4, 2013 at 7:09 am

  #1663803

  hoseam (11/1/2013)

  ---

  I need help here, I have this table, I may need to create another column I'm not sure yet.

  CREATE TABLE [dbo].[Location](

  [LocationID] [int] IDENTITY(1,1) NOT NULL,

  [Location] [nvarchar](255) NOT NULL,

  [Product_Code] [nvarchar](255) NOT NULL,

  [LocationProductStockAmt] [decimal](18, 2) NULL)

  And I need to create a database object that can store hierarchical linking of locations to each other. Ensure referential integrity is enforced.

  One location cannot be linked to more than one parent location.

  For example if I have location South Africa and I want to link Gauteng and to Gauteng I want to link Johannesburg. South Africa => Gauteng => Johannesburg

  Duplicate post. http://www.sqlservercentral.com/Forums/Topic1511001-391-1.aspx

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions