does your tree look like this

1

--2

--3

--4

5

--6

--7

--8

That is the structure defined in your #Original table.

the data in #New doesn't mnake sense, because the top level and submenus are mixed up in...

This is not really a SQL problem, although SQL will be part of the solution.

Assuming that this is a web based application, you will need to make an asyncrinous Javascript...

What do the three columns represent?

I think there are some logic errors in your desired output because the results do no appear to be consistent (which makes it difficult to...

if you have 150K columns, how many rows?

Wrong board I think...

SQL doesn't use foreach loops, it is a set based language. You apply the same change to every record at the same time (unless you are...

do you mean global ##temptables

These persist between stored procedures until the session is ended or the connection is dropped.

you can fill a ##temptable in one procedure and access the data...

Joe,

Can we reset the argument here about what we mean about a primary key and foreign key. I have read the intro sections to a couple of your books...

Celko, I'm really not sure where to start....

I fear for the next generation of business analysts and DBAs if this stuff is included in your books..

"It is recognised, recommended...

They did - they were working in Progress :-P. It was...

[quote-0It's quite common for a product to "evolve" over time without its' stock code changing - it's rampant in the fashion world. Clients, agents, reps all know an item by...

yeah, don't use the wizards, learn to programme - it will be quicker in the long run and the next developer will thank you for it.

fine, but if you are creating...

Look at the concept of n-tier architecture, or MVC patterns.

The idea is to separate out different processes and let each tool carry out it's area of expertise.

E.g. Let SQL...

Yes, an example is in my original post; where you convert another value and compare the results. Most...

Generally when encrypting a password you will use an algorythmn (spelling...) like SHA1

The point of this is it is a one way encryption. When you come to validate it, you...