To view the taskpad in EM, right click on a database, select view... taskpad.

Use brackets in your where clause.

...

WHERE

(

tblProfile.Education = 'Some College'

OR tblProfile.Education = 'Associates Degree'

)

AND tblProfile.MemberIDpr = tblUsers.MemberID

...

Have a look at this article...

http://www.sqlservercentral.com/columnists/hji/trace.asp

I have found it invaluable in identifying databases which are rarely used.

Good question, I have also wondered about this.

I've always tried to avoid the use of "Select *" in any database queries. It's better to explicitly define what columns are...

Chief, I agree. My first line in ALL my stored procedures is always SET NOCOUNT ON.

Nice tip on concatination Antares686/rmarda.

I prefer SET over SELECT. Basically an aesthetic choice.