Thanks again Jeff,

I just read the article. And it is just awesome! Exactly what I needed.

Thanks,

Chris

I'm now running into another snag with this setup actually. I need to build a website hierarchy menu out of this (it doesn't have to be based on url's...

Thanks, I think that will work for now.

Thanks Jeff,

Here is what we have now:

Table and it's indexes

CREATE TABLE [dbo].[UrlContent](

[pageid] [int] NOT NULL,

[varchar](500) NOT NULL,

CONSTRAINT [PK_UrlContent] PRIMARY KEY CLUSTERED

(

[pageid] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

The reason I think it makes sense is because hierarchyid is stored in leafnodes so that when I have to get the id (which is what I'm after) by parsing...