Yes, I did open the link but do not see how using a left outer join will help in those case where the join key in the dependent table is...

Do only Agents with codes begining with 13, 17 and 19 have sub-agents? (or was this just an example?).

If all agents may have subagents, then this SQL comparison might be...

Actually, is this case only, the two SQL statements are logically equivalant and would produce identical results.

The join criteria is "ON hst.InvID = inv.InvID" and since nulls = null evaluates...

Local temporary tables are visible only to the creating session but global temporary tables are visible to all sessions.

To create a global temporary table, prefix the table name with two...

Did I miss something, or are we not in the twenty-first century?

Here is my opinion on "Who were the top ten people of the twentieth century to have influenced the...

Just curious as to why you are trying to save the password of generic administrative SQL logins. The auditors will not be happy that generic accounts with known passwords...

For the case when the same user has more than one row that has the same high score that is the greatest, then the comment to be return will be...

Your SQL attempts are very close.

As all SQL statements have "input" of a set and the "output" is always a set, this set can be used just as...

Are either of the servers Windows 2003 or even Windows XP?

MS made some security changes with 2003 and requires that you create registry values for all XA DLLs that you...

The SQL Server login for a connection can be determined from the system function

SUSER_SNAME()

Of course, if this is a multi-tier application where the application always connects using the...

Sorry, you are correct but there are workarounds.

See "How can I fix a corruption in a system table? " at http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=14051&DisplayTab=Article

As the stored procedure sp_fixindex will check to confirm that...

You could try, but then run checkdb again.

No, you master database has significant corruption and "allow data loss" could mean such things as logins, security rights or user databases "disappearing".

First, make a backup of the master database.

Second,...

From Books OnLine:

Comparison Operators

Comparison operators test whether or not two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image...

Your original question:

And your follow up:

Let me be perfectly clear:

THIS CANNOT BE DONE AS THIS INFORMATION IS NOT STORED INSIDE OF SQL SERVER.

This information is only stored in the Windows...