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.
Sure, call it old technology. That's why we see it all over the place in SQL Server from job schedules to SSRS.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events