I have little experience with how the ampersand works in the context of SQL Server so I'm hoping someone can help me in that regard. I have a stored procedure that returns a bit indicator for a status. Within the sproc I have the following code:
declare @TeamEventEnabled int = 0x1000000;
iif(@EventStartDate > @NewTeamEventEffectiveDate AND @EventType = 0 AND @MyAccountStatus & @TeamEventEnabled > 0, 1, 0);
The other variables are parameters fed into the sproc. The first two conditions of the IIF statement are straight forward but the last one involving @MyAccountStatus (this is an int) and @TeamEventEnabled puzzles me. What exactly is it evaluating?
Thanks in advance,