I'm trying to figure this query out and can't figure out how it relates:
Where iInteractionOpenReasonID & 16 = 0
Possible values for iInteractionOpenReasonID should be:
0 Unknown
1 Normal Start
2 Normal End
4 Transfer Start
8 Transfer End
16 Conference
32 Inter Queue
64 Networking
128 Segment
256 Compound
512 Block
1024 Clip Recording
I'm seeing values of 129 and 145 (which aren't in the list) and that where clause filters out the 145...I'm confused
"The & bitwise operator performs a bitwise logical AND between the two expressions, taking each corresponding bit for both expressions. The bits in the result are set to 1 if and only if both bits (for the current bit being resolved) in the input expressions have a value of 1; otherwise, the bit in the result is set to 0."
Try looking at the msdn doucmentation here. http://msdn.microsoft.com/en-us/library/ms174965.aspx