Well it still seems like something is missing, but this code does what you have specified:
;WITH cteBinary as (
Select
SUM(
Case [status]
When 1 Then Power(2, ResID)
Else 0 End
) as [Bitmask]
From Table1
)
SELECT
t2.Rvalue | b.BitMask as [Result]
, [status]
From Table2 t2
Cross Join cteBinary b
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]