sql server programming: hi guys!

just want to know if the answer on this thread is the best one. please
check it out:
http://msforums.ph/forums/87274/ShowPost.aspx

i don't know if the bitwise operation generates the most efficient
query, please verify, thanks!

[quoted text, click to view]

Why don't you test it out yourself? I suggest a better solution would
be to fix the faulty design. The sample table doesn't have a key so
eliminating the redundant data would be a big improvement in both
efficiency and integrity. That would be my solution anyway.

--
David Portas
SQL Server MVP
--

hi david, sorry for the confusion.

the table design was given and not a live data. we just have to find
the right and most efficient query to get the desired results given the
said data. i don't know how to test the queries since i don't know how
to read execution plans...