Lynn Pettis (3/18/2013)
Jeff Moden (3/18/2013)
Evil Kraig F (3/18/2013)
Ahhh, bitvector (bitmask, bitwise operators, combined flags, flagfield, etc...), my old friend.Alright, let's start with the basics. You said you've read up on it but some of your difficulty shows that some of the basics didn't quite make it through.
You spent some time on that post! Nicely done. I know bitwise operations are "old" technology but it still works great and there's fresh faces out there that think AND is a question. You should write an article on it, Craig.
And?
Two in one on this.
@jeff: Not as much as you'd think but more than usual. I appreciate the compliment from you in particular, and definately food for thought. A possible result is formulating in my head, but I want to at least show the particulars as well as the articles that Steve linked.
EDIT: I should probably mention that if LSAdvantage hadn't been willing to show everything, including giving me sample structure to work with from the getgo, I wouldn't have cared. I've come to sincerely appreciate an honest question where the request shows as much effort as they're asking for from us, and don't mind going out of my way when I have time to give it the proper response when they do. /EDIT /SOAPBOX
@Lynn: Huh? 😛 I don't get it. I blame the beer... and the ladies who assisted me in drinking it.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA