Select
PartyId,
FirstName,
LastName,
Case when Source&1<>0 then 1 else 0 End[Source1],
Case when Source&2<>0 then 2 else 0 End[Source2],
Case when Source&4<>0 then 4 else 0 End[Source3],
AddDate,
ModDate
from dbo.ExistingMaster
Will you please let me know what Case when Source&1<>0 then 1 else 0 for in this code ?
Thx.