Thank you very much dave 🙂 U made my day today.. This is my early stages into sql and iam getting so much needfull from u which will help me...

Iam have one more way to get the answer :

DECLARE @counter INT=0

SELECT @counter = @counter |CONVERT(INT, RoleID) from UsersRoles where UserID = 23

select @counter as Result

Could you help me out...

Thanks for your valuable suggestion Dave. You Made my day really..Could you give me some good example on this..

Hi Dave,

I got the answer that i was looking for..its working for me great..

Thanks,

Ram

Hi Dave,

Here if the roleid for the user are 4 and 15 it is showing the output as 7 instead of 15. Could you please verify and send me the...

Hi Dave,

Thanks for your quick reply. Iam having one doubt here what if the roleid for that particular users are 2 & 6, then how to write the query as...

Hi Lowell,

Thats nice to hear from you ...as told by you it would be great if you could provide me some examples

thanks Lowell 🙂 you saved me..that is what iam looking for...Iam new to this field..iam learning a lot now...could you please provide me some good example if u have on...

Thanks a lot Lowell, Can you just guide me how you could do SUM the bitmasks...that could be more great help

For eg : SUM of 1 & 2 = 3(1...

Please provide me the the query that works without using bit operators...

I need it very badly 🙂

HI Sarat,

From the table which i have given as above, I need the query to get the SUM of the bitmask values like :

eg : Select *

from BitmaskDemo

where Bitmask...

Hi All,

Thanks for your reply. But iam new to this field. i wanted to know how do we assign a mask value and how to do multiple selection through bitmask...

Thanks a lot, it worked for me and saved my time. 🙂