I don't have adventureworks installed so I'll have to wing it..

If you get the email list into a table it becomes pretty easy..

DECLARE @Wk TABLE ( RecId INT IDENTITY(1,1) NOT NULL, EmailAddress VARCHAR(100) NOT NULL )

INSERT @Wk (EmailAddress ) VALUES ( 'ken0@adventure-works.com' ),

( 'terri0@adventure-works.com' ),

( 'roberto0@adventure-works.com' ),

( 'gail0@adventure-works.com' ),

( 'jossef0@adventure-works.com' ),

( 'dylan0@adventure-works.com' ),

( 'diane1@adventure-works.com' ),

( 'gigi0@adventure-works.com' ),

( '25terri0@adventure-works.com' ),

( '25roberto0@adventure-works.com' ),

( '25rob0@adventure-works.com' )

SELECT States = CASE WHEN ea.EmailAddressID IS NULL

THEN 'Email Address Is NOT Present'

ELSE 'Email Address Is Present'

END

EmailAddressID,

w.EmailAddress

FROM @Wk w LEFT OUTER JOIN [AdventureWorks2012].[Person].[EmailAddress] ea

ON w.EmailAddress = ea.EmailAddress

GO

CEWII