[dba-SQLServer] interesting trick

http://www.sqlskills.com/blogs/conor/2008/02/07/EXISTSSubqueriesSELECT1VsSELECT.aspx

I've never even checked to see if SQL Server supports this SELECT syntax. 
Never needed it and can't imagine using it, but in this one particular case, 
seems like a good choice.

Susan H.