Right,

You will have to be a bit clearer about what you want to do, do you want to delete orphan records as in your original post or do you want...

Sorry,

I just saw in my haste I never tested the code I posted, there were a few errors as I was making use of a different table name than the...

Hi KS-321165,

This will tell you which children's parents do not exist

SELECT

*

FROM Table1 t1

LEFT JOIN tt AS Table1 ON t1.ParentUnitID = t2.UnitID

This will give you the records where a...

Hi Azdeji,

To get the results in the format you want with each level being in a different column, your best bet would be to join the table multiple times, but...

Ya, see, if you already have a data set in your original schema, it makes it a bit more difficult, as you will have to migrate your data to the...

Hi WWDMark,

That seems to be quite a common problem from what I've seen in busines, Excel is just so convenient for most users since is is more WYSIWYG than most...

Hi Azedji,

The structure below I think has a bit more flexibility, you will see that you can add a role at any time, there may be better ways of doing...

Hi Azdeji,

I am glad it worked,

mmm, to do that you may have to change your schema, you will be able to make it work as is, but you are going...

Thanks for clearing that up,

I must say, I have never lost a db by stopping and starting the service (which I would not try on a prod env, but on...

Hi,

I am pretty sure if you stop and start the service, it stops the rollback operation, after that, you can drop the table removing the keep history button, since you...

Hi azdeji,

I understand what you are trying to achieve, but you won't be able to do it with an update, since you need to create rows for each possibility, you...