If you "Check out" Ehsan's example you'll find Jack is retrieved even though he did take the class and, even though Bob did not take the class, he is not retrieved.

"Stupid people...

Wow!  Look Mom, no cursors! 

I'll have to expand my set-based thinking to include the imaginary set of "all" possible values.  (The #Dollars table in your example.)

Thanks Mike!

Mike C wrote:

"Very, very, very rarely is a cursor absolutely necessary.  There is almost always a way to conquer T-SQL tasks using T-SQL, sans cursors.  Over-reliance on cursors is a...

Thanks for a great article, Steve. We are using most of the conventions described in it (OK, maybe not "15-20 character, mixed case, numbers, letters, very strong passwords") and at...

I've found Viktor Gorodnichenko's sp_CompareDB stored procedure to be very helpful.

http://www.sql-server-performance.com/viktor_gorodnichenko.asp