Hi.

I am developing an application based on SQL. I want a folder structure and
security based on these folders. That is easy, but I find that I am
replicating the security info in subfolders, subsubfolders etc. So the
choice is to use inherited security and here I need some help.

My security info is stored in a binary field. When applying the security, I
would like to see if there is identical data on the parent, parents parent
etc. All the way to the root.

Can anyone provide an example witg TSQL on how to do that?

Vilma

tough request
How to combine several long strings and then insert them to a text field
Urgent: Help on query
Copy SQL ResultSet to Variable
Parse Text Problem