want to set a var in IF EXISTS subquery...can't

[organicg]

This statement works:

 If EXISTS(select ReferredByUserID 
			from Referrals
			where ReferredEmail = 'me@you.com')
  PRINT 'YES!!!'

However, I want to retain the value of ReferredByUserID for the next statement. Why won't this work?:

DECLARE @UserID [int]
 If EXISTS(select @UserID = ReferredByUserID 
			from Referrals
			where ReferredEmail = 'me@you.com')
  PRINT 'YES!!!'

 

[Bygbobbo]

I believe the If Exist() statement will only evaluate a true or false. I dont believe it supports holding/setting scope of a variable.

Thats what makes the exists statements so efficient.

Is there any reason why you dont set the variable before then evaluate?


DECLARE @UserID int
select @UserID = ReferredByUserID
from Referrals
where ReferredEmail = 'me@you.com'
if(@UserID is not null)
Print 'YES!!!!'

Bygs

 

[organicg]

Thank you, I knew there was an easy way to do this with only one query.