I agree, the books from Itzik are the best ever

Great article, looking forward for next step.

I had a little problem when running the query - but it was easy to spot where the problem was.

SELECT

...

Although interesting, your coverage of SUBQUERIES is far from complete.

how would you query:

1) list employe-name for the employee(s) with highest salary

2) who is the manager with the highest salary employee(s)...

I like the article, but would like show a variation that will produce the same output, with the advantage to be able to do other controls if necessary (instead of...

I did, and fixed a minor problem: If your SQL Server is CASE SENSITIVE the original code won't work due some names spelled in CAPITALs. The attached .txt file fixes...

understood, but not practical at all...

Thanks Wayne

I saw it, and I actuallly ran the code (had to do minor adjustments due case-sensitivity of my SQL installation here). But the code does not retrieve data from any...

Nice article, but I'd like to see how to actually work with data, i.e. retrieving data from a table or set of tables - or calling a SP to retrieve...

try to create a SP that actually does something with a table.

and then execute: sp_depends to that SP or to that table, that was my point.

so you'd use the results...

All you needed to do was to recompile the function (or drop and re-create it)

Explanation: All compiled objects (Stored Procedures, Triggers, Functions, views, etc) are stored in the database in...