It looks like you use assembly language bit flays
Until SQL support Boolean datatypes, bit flags are the next best thing.
, but you did not bother to post any DDL so we have no idea what help you need. Just follow basic Netiquette, please.
Perhaps you should try reading the thread instead of pushing your personal agenda. The question has already been answered, so obviously there was enough information provided
J. Drew Allen
Business Intelligence Analyst
How to post data/code on a forum to get the best help.How to Post Performance Problems
Make sure that you include code in the appropriate IFCode tags, e.g. [code=sql]<your code here>[/code]. You can find the IFCode tags under the INSERT
options when you are writing a post.