>>Hi all,
>>
>>Problem is I need to do do something as a multipple of the bits set on an integer, the integer is a bit array to store statii.
>>
>>I need to figure out how many bits are set on an integer.
>>
>>I know I can loop / iterate through the number and bittest / divide by 2 etc.
>>
>>for now there are not to much so I can do with an ICASE, but I like it generic :)
>>
>>Any ideas for a fast solution? Something mathematical?
>>
>
>
>Maybe a loop using BitTest()?
>
>Tamar

off topic

Tamar,

just by the way.

I remember your session with MS SQL and the CTE. Christoph points out some limitations of it and how to go around in his session. Mayve you have a look there.

Lutz