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!

joeycalisay wrote:
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.

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...

Dynamic WHERE & Dates
with(updlock) - How many times on same table in single update?
Composing a date from date parts
Delete Query ?
COUNT of datediff