Thank You to everyone. I just could not wrap my mind around the self-join. It is a slow moving monday for me, after a long weekend of moving into a...

Thanks Everyone

I always learn something everyday on here. I too love the performance tests.

Andrew SQLDBA

Thanks Everyone

I appreciate all the comments.

Andrew SQLDBA

Thanks Everyone,

I think we got it figured out.

Thank you to all. Hope that you have a great weekend

Andrew SQLDBA

Hello Everyone

Since the Highlight did not work well, I have added a column to the sample code to help.

DECLARE @RoleRanking TABLE

(

RelationshipID int

, ParentID int

,ChildID...

I should have stated this in the first post. But never really thought about it until you guys mentioned it.

SQL Server will not let me query the table, with the...

Thanks for the good news 😀

That is what I thought, but I was hoping that someone had found a way.

Andrew SQLDBA

Hi Lowell

Thank You, the query in the middle came closest. It will return the table name and the object name that the the table is depended upon.

This is a good...

Thanks Everyone

Kiwi

your code worked perfectly

Andrew SQLDBA

You should have xp_cmdshell disabled for security reasons

Andrew SQLDBA

Thank you Very much for all your help. My code is now working perfectly. I like the use of Coalesce, much cleaner then using a CASE statement.

I am working on...

Steve

Thank you for your reply, and sorry that I was not more clear on this issue.

All the data used and shown here is from the Pubs database, but the basic...

Craig

After going over the results very closely, you are correct, and your initial code was perfect.

Not sure what I had seen that I thought was not correct.

I apologize to you...

Sure will

I have been working on it, and going thru the small list by hand to see exactly what rows are not in the correct place. I am coming close...

Thank You Everyone

I was close, but just could not get it correct.

Greatly appreciate all the help

Andrew SQLDBA